Skip to content

How to solve accent sensitive problems?

Some days ago, one of my customer claimed that searching for “Muller” doesn’t return “Mueller” and “Müller” as well!
This is typically an issue due to the collation of the SQL Server database, but how to resolve this problem?
The collation of the database is Latin1_General_CI_AS, so a case insensitive and accent sensitive collation.

If a run the following query:

Select name from Person where name like 'muller'

[img64 src=”data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAMgAAABRCAIAAAAYU35CAAAHXElEQVR4nO2dT2/iOBiH/Z0cKuW7TIo44M+xhRmpJ3qr5BsHlBZt9kKlnrmsShurndWuRKWKU7WzNC0l6WX4Uyl7MHFiSGjoYBLgfWTR2LGjNHn6swOMBrmu57qu67pDUYbucOi+RsvrrAyC8jpXhu7rcPg6XBV37QTnv+OkvBpedqD131tg7wGxACVwsbysTwPYNTzPQ7e3d9YukvW13Ws8z0Oj0djfOUCsbNllsfaHrC2KwfM8NBrvplhZX9sNkc/fdJlYhLLYgsl82bA0abAsa+6Nn3a73W63WzL1eiOLN6HWyVaKRZk/K9QnCWVbxKJ0/jwdxyGUZmLDGtlKsT7MKkwYxgliPZzoSIJcfsqRhxNdP3lYcZBlWa8yQizP89iLz15888YlhL5uOfkVa5wgVvRP3LZtsd1ut/nGaDSilGFMUgnxKT/CgSsOTxKr2+0yxmzbNm9cShmIpYi0YgmZfN9vtVq+749GI8/zKGW6ri8TIqxfks9l1mfFGshQyihjrVaLUlavN3ghhA5SYn/VEELFplTXvtppx6ti+8Sq1xvdbte27bYMvzd85buCWKIaTpGz3aJBP3mQRoVKEaKHI6T+yWK9yCyuscwbdxZdjFHGer3eyxKuq5qmaVr1WlQRQqKaHfkUy3VdNB5PksQS29HEopTxj6/Zi1+vN5aJFbPEiogz2wyS7OFER+QyXqxoYsn9VxHr8fHRcRzHcRjzzRvXvHGjvxTGZJlb11VNq1YPA5XOD7XDQw3ESiZRrNipcDQatVotsf79QKwwUgIL5m3jysjx9YFYcv9ksZ5lKGW9Xk/KXcb47+lTQimzbZu79RzLdVXTqtfnh1r1+vn5+fxQq55XNV7h6YV4gj1HG+b2B2PD3//w/FkasDgm4ZiC7RPr9PSUMcZvg1id8FexTKGUpp0KedAkx8wlQShVYsn9k8VyZBanwplYvu/7fq/Xw4RgTDAmTiydCsaVDn91zoxwe/Yj7OOcGcg441VknM1XF44Z3ZH2mCFbKVZ4Dyjjq3XP8+r1Bnvx+Wxyenqa9qlw0Swx9yGx+NJPHiJr/EuCFsWa77+aWDxrHcdhL4FYlPiE+L5PKKaUYbJULKdTwcYZv8tCNSmDw6aIGtGqaIh0F/vSHnNXxOLTn1hXiTXKKmIJpS7JksW7tLjXI0rxUdJ0unzx/iQjxOJWsRdprvc8r9frUcYwJk+x8FvOf2JsmEFLp4KRYcaNMA2EIruCqmkgXOlEjhkcWWpJd8ynp6etFEs8A0anP/4weBqQKFamWJbVl+EaCasYC8QixCf48fGRUMzF6sdydYTx0RXfQIYZtoh6sOvqCCPRFR+ZcvXKNILufdNAi0dIc8yr8Ly2Uixd1zEmc6/RDc4mjUnJB2IxnzAsHnsdx+l2u+12mz8bfiBWTItpBHMWr18d4Wg9qRrflO6YWyzWVmNZ1n8y/LmPv03Ky0wsgn2CbdvGBHOx/suQxhf0pbHSCBBro1iW9UOGL8yLxSImhBcu1uwN0mCux5j82DSNL5EE++3P1QaDWBtlUaxFuEaL5XN2ZAWItVEsy/p3P8izWLv5DVIgQ25vb3dTLCBbRqNRKNbvf1xAgbKWcvf9b0msd5X0vanS46en702z+2PeC8bjMYgFrB8QC1ACiAUoAcQClDCZTEAsYP2AWIASMhXrvqbrtVp59ulr+eL9/f39ohx+Hlu+4H3KZf4l99pFbbZxPxsefCGQN6x0Jtle950na7ECn7hk93N79dr9fU3n3kQ39Np9dMDi2BRnku1133mm02nGiXU/tx3mEEJcLNEe3Yh2Wz20QCzV5E2sizKSc2iZWOVPny6IpZocihXowh1LEus9YtbqkoFYqsmbWNJMuFSs98hCHxbvuSNTsbIDxFINiAUoAcQClABiAUqYF6vvTfekZHvdd555sZT/yw2E8vCa7UXfB2LEUjcBua7bH7xlXlzXXX5RgF9n02IhhDIXCxJrA0BiAUqAxAKUkF6syKd4vyBW/M1mxxpCqGgFLXeVAkKF405sz8Jxh79CYuWYNGKJj+/WIFZ8YrFjrXAQusI9UyYWJNYGyE1iFY4rxYMKe+sP3vrNklYsxasDibUlbFqs5MQ67jRL2re7/uDNLB5UmgsCRZUS7TzbEELooMJ4n5JRQAiVTEisTMlRYgW6WMaiQPFi3VUKQciJdhS0QGJlSp4Sa3BXKZTMZgkVrZgpb1GsMK6C0GqmmiIhsTZAnhJr8Nb5dqAVDoxm3FoqXix5yku39oLE2gC5Siy+ZiqZYYtlCHWaJRQzFSKjKR4kS2Y6sSCxNkC+Eis2w2YTHX8/Yj7JLGN+8Q6JlQvgnXdACfBZIaAESCxACZBYgBJixFL3bWBIrP1h019NduF7yfvBvFjZng2wM4BYgBJALEAJIBagBC7W7H//ArGAdQFiAUoAsQAlgFiAEkAsQAkgFqAEEAtQAogFKAHEApQwnU7RZAJiAWtmOp2inz9/TiaTyWTy/a9/JhJTAPgc4/H4fy/F9ip/4wJNAAAAAElFTkSuQmCC” alt=””]
I get only “Muller” which is normal as I use an accent sensitive collation so u is not the same as ü…
Next, if I execute the same query by using an accent insensitive collation:

Select name from Person where name like 'muller' collate Latin1_GENERAL_CI_AI

I have as result:

[img64 src=”data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAKcAAABeCAIAAADJ6ZNqAAAIdUlEQVR4nO2dTW/quBqA/Z8cKoXfclLEov4dU5iRumpZVfKORZUW3dwNlVizGZUWz+mM7pWohFhVM0NTaKFzWhKo5Fk4cT6BhAKhtR9ZNHY+FPLkfe2EFMDrm2XbU8ueWvZ0Yk0n1vTNst8m9uvEfn2zf7zZP16tf+aUH6/Wj1fr9Y2Vyduy8jGsibWcycT67bfvz8/PT8/PT0+sPA2fnoZDfxkOhsPBMB2D5aTcYgqeYnkOMprDOAKw7Sn9WhgiMc/0Ar6s9RWOxWdkzdYRJrEFonDZvtSlGIYRSn3NZrPZbNaDVKtnz5+c9VvHhDoFUzSnfBbrGIf30zRNhHEmqtbIxmM9GuUQEQjnWO+eqCAAaqwksHuiqifdlCsZhhEa9XDr4/GYDCgZUP1mhBCOHyN9HtZs3R8c7XabTzebTTZhWRbGBEKUyNZK8rwVU64+z3qn0yGEtNtt/WaEMZHWw/itc9OU0nq9Tim1LGs8HmNMVFVdZMurN9Bq0b6q9dB1D8YEE1Kv1zEm1eoZKwjhpNdN7Z8VAEChFqgrP7fXdmG2IiuPW+OtV6tnnU6n3W43g7ADx4ZCKazzqpf5ndm8QT3pBtbyfCOkemsElp9vPXQdHe3X9ZuRE/SEYEJ6vd6i6/DrsqIoilK+5lUAAK9mx/qt82l/rGNM2GU+GdBq9WyR9Zhu3WfVmXRzQPdEBagRb90f68Hl01i/v783TdM0TUKofjPSb0b+NwUhWiT+uqwo5fK+6/liX9nfV76e9dgMb1lWvV7nA6Il1r1gdBWFTwXmMxj4S6wHl59v/TEIxqTX6wUyFiHsfVKMMCbtdpuJf4zluqwo5euLfaV8/fj4eLGvlC/KCquwuAcs9h/9DaH57rre+9+/eAysEF1nzjY5H7FuRw/c6ekpIYQdI94jslfeNWKMk2Z4FqLzA7SBAEgU68Hl51s3g0QzvGOdUkppr9eDCEGIIERmLK0ShKUWezXPNW/a+eMtY55rQDtnVaCdh6uRbfpnJN2mx/qtewcIEzZ8G4/H1eoZGVCWJE9PT5OO4aPaeUoHvMNXT7q+QV8Dgaj18PLprLMsZZomGbjWMaIIUUoRhhgTiBZaN1slqJ0zBfw8CGQvr8nnzV/lDb7F+byk29yKdZbVeV/O+8U01rnvBlowmguM9lSfb7ZWoJdYPJp7CMKtM+VkEOjCxuNxr9fDhECIHmJhPthfCDXdbWmVIND0uDV0DQDfLLeqawCWWr5tulsOtCTb5sPDw/qt8xG7P6uzofupy1zrmWIYRj8Ic8yVE+JaR4gieH9/jzBk1vuxXB1CeHjFJoCmey287s66OoSALwoP9WD1Stfcxfu6BqJbSLLNK2+/1m9dVVUIUejVP8HYstEkLLFOKCKQX6SYptnpdJrNJhvJL7Ee06Jrbipm9atD6K/Pq8Y3Jdvmpqx/agzD+DsIG6WzezWsONYRpAi2222IILP+d4acfQPfzlKtIa17GIbxVxA2UisUChAhVph15y6N24VBiP7aNmfffLH/06/pVpbWPaLWozDH0bKauqyQ1j0Mw/hTDKR1j00+sPQV+P79+xe0LlmMZVmO9f/891IWQcrt7//zrL9vkv54ttHtJ6c/nmUdbBlj27a0LhzSuohI6yIirYvIdDqV1oVDWheR7KzfHavq8fGB87HDweX7+/v75YH3QcTBJVvm4IA9KHd8eexM3Dmru09fsIZUe5L1Yc+YTK27stkZcBeaqx7f3R2rTKp/Qj2+868QXTfBnmR92DNmNptlGet3oWkvggFg1nm7f8K/WPpwl9Z3yvrlAQhG8CLrByvvrrS+a9Zdl+wEmGf93ac9/Rkgre+U9UCCX2j93Tfyk6O51GRnPTukdWldRKR1EZHWRSRgvT+eCVKyPuwZE7C+2tOWKZ7LBGAXXrM+5tkTtr65vDoajfrDl8zLaDRaelC+PFu1DgDI3LqMdSpjXUxkrItIQuu+O+QfsB5vghwpAICC4bbclnIA5I5asUvmjlrsVcb6B1hqnd8aX4P1+FgnR0puzxPJToKNWZexTncl1nNHpcJeibz0hy/9WlEpFOO9ylhfE1u1Pj/Wj1q1ovLLbX/4ohf2SrWIXb9v3s6yAgAA7JUIW6ao5QAARV3G+kJ2JdZdl4YWtRtv/baUc9MDbwdui4z1hexMrA9vS7miXiuCghGTyaPWvUB3w72WKPPLWKc7FOvDl9Yve0puT6vF9d/x1oOZPFl/L2Od7lKss366qHsthsa91oogJsMDrcaH/UU9mXUZ63SnYj02+p38zS7twjnA0MKjORnriZD35kRE3ocXERnrIiJjXUTC1jf30JKM9d1hq09QjXbg8SkZ63TLGT7rN0sppTuyG9kym82AZUnrYiGti4i0LiLMukXnW/e+NeRj92TnHu5uJQ/8v9fUreQByFe6znS+0mWv4dpqSOt0qfUP/Z94cuv5vCeSnQSxXqX1NbE81v1nQOp/FU9qvVJBrskGyiMU71VaXxPJrW801ivdhqO9gfKVRsSu3zdvZ1kBuJmhW8nnEQr2FlGkdZrcOv8SqE1Zd1w2UNQujbXum83b4zuGANI6TWj948qXW6fdSh41nF94TGDdC3Q33BuJMr+0TpNYX4vyBNadUR1qxPXf8daDmTxZfy+t0+XWLw8+/v8PCa1TLpJne/9vtsZkeP6Tr5U8QA1pPTFL7tL4v+ITrPB1T6msR1p8w7V8zGjO+8lX39X8sjcsrVPHuvz0RTDkZ24iIq2LiLQuIlt9girrN0uptE4p3f4TVJmT9QHfCQLWs94ZyZaQ1kVEWhcRaV1EmPUpldZFQloXEWldRGazGZhOpXWxkNZFRFoXEWldRKR1EZHWRWQ2m4HJZDKdTn//4//TADPJV8W27X8BIoU7gkegWQ8AAAAASUVORK5CYII=” alt=””]

This time, “Muller” and “Müller” are retrieved as my collation is fully insensitive. For Latin1_General and AI (Accent Insensitive) collation u = ü, o = ö, a = ä…
But I get not yet “Mueller” which is a synonym of “Müller” without using a ü in German writing.
So I decided to use a German collation to see if it could solve my issue by returning my three forms of “Muller”. In this phonebook collation, ü is sorted like ue, ä like ae…

Select name from Person where name like 'muller' collate German_PhoneBook_CI_AI

[img64 src=”data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAKQAAABMCAIAAABswIv5AAAIRUlEQVR4nO2dTW/juBmAed8/kB8whzks9kI5qHopMNnb7vS6l1EMFwhP/RGNvQvklNwC8OZDoMSoenGKoIcejAWK2BaT7G6LsYHACwyC2XGUZGqlg1iyA7w90Pq05MgaJ7JjPiAckiIFWk9eklKEGdTp/MpOThg7YexEZyc6O2nqJ02dNXTWaLJGk9UbrN5gx6Ok+1PdSQ2emqPU9NIE9M+APchHh5uPH29uUqcZ8nHm/DdELxbTNE3TRHf9Pjw7NE2L/+JLimmaqN+3slYze7RlQshelsie4ptOkE0oi0yYhNMTi0yCpmmh5axWq9VqtWqQcnkvvOwtGlP9WqO+FSubMhglCiQmLYpsSsPjNAyDUJqJoRkyM9kPxjQmDOMY2ec7MgpAjlJ5O9+R5Z3zKTtpmhbauLqyTdNk18CuQW32CKGz3yI/LdPJtiw78nr5Q0HXdTdfq9V4xrIsShnGJJGkVM68jlN2j5PdarUYY7quq80epUzIHuGX7QoGgGq1CgCWZZmmSSmTZXmSJK98RNLFdlrZoZtcShllrFqtUsrK5T2eCKFJb5L17yWEUL4SKEvf6zO7C0/JlLLtaNnl8l6r1dJ1vRaEXy++u5lCtlv0pvfRYbdC3jkP9PI0EyJ7PQLt42VfBxlfs9VmbxTijFHGOp3O9QQaJUmSJKnUcIsIIbeYHTOT7eb9kU0p449j2DWUy3uTZEcs2T6Zo6wT8ec7MiJH0bL9kR1sP43si4sLwzAMw2AM1GZPbfb8XwpjMsl3oyRJpdK6o/dgXVpflxZOth0jO3IatyyrWq26e5wHZHuh55gJ/wZwjcEwf0B2sH287KsglLJOpxOYnxjj3xMooZTpus59X0XSKElSqXGwLpUaV1dXB+tS6aAk8QKPcsQj/cpfETru9PW+//rBVaDDeJ+Yc7rMRvbu7i5jjF8ad7Xjn+6yRylNOo3zgIwPxyOCUKLIDraPl20EGZ/GR7IBAKDT6WBCMCYYEyOSehHjYp1/GvuKlx/98NoY+wpS9nkRKfvh4tg5/QeSntNjZrK960IZ35GZplku77Fr4DPh7u5u0t34uG133kbuYi7vnPv2cUcEjcsOt59ONp+TDMNg145sSoAQACAUU8owmSjbqBexss+vvKs/MFd5VT5d/qJb4WvuHkt6zseUzadud51217xpZLuaj8iEDVpgAyf7NPNegaVg8gbtMogrm5tm14F1yjTNTqdDGcOYXEbCNfCfGCuqU1MvYqSoUT1UBSHfIaeoKggX675zOmcO1CQ75+Xl5cxku3tv/9TNN+G7DrGyM0XTtG4QrtY1zZgjmxAg+OLiglDMZXcjOd7EePOYZ5CiejVu2Tl0vImR2xRvqsHisao4zbuqgsbPkOScx964ZiZblmWMSejTn+E8pcWEPCCbAWHYvd0wDKPVatVqNb4nf0B2RI2qOPMtLx9vYn85rhhdleycqWUPMvXyKGia9iEI32/zRys8jWQTDATruo4J5rI/ZMjeG/Rmb6oeQjZomvZbEL75yufzmBCeuOzRQxVnncKY/PbU7L3xRfpf/jVdZyE7QvY4XO14SmcsK4Rs0DTt/XIwmw3aQvOYbwEtKqenp89TtmAcy7I82X/926FIzzid/fTvgOz7x6RrDh/1/MnpmsPsAiwzbNsWspcFIXuJELKXCCF7iRgMBkL2siBkLxGZym5vy/L29sboLwAbh/f39/eHG97fBDYOeZuNDf7S2fbh9ijTHnV3XnLgFVONJNvrnglZy3Ycc/Ht0FF5u93elrlLf0bebvs7jPdNMJJsr3smDIfDjCO7Hcp78YoQl+3W+zP+ZtMHt5A9D7IPN1AwXifJ3kg9XCF7TmQ7Crn3ONn3PtvTixey50F2YBafKPvet5kTG7REZCo7O4RsIfuZI2QvEUL2EhGW3TWHS5Kyve6ZEJad/D3FdCCE5uEz24ueFRGyH2/y7PV63ZvbzFOv15t8UZ4rTy0bIZS5bBHZACKynzsispeI5LJ9T60/Q3a0ALYlIYTymlNzVswhlNuqR7bMbdX5p4jsKUki231cPQPZ0ZHNtqTcquePu3802SKyAbKN7NxWMb9aZLfdm9tupSDlC9E6RWR/Bk8tOz6yt+qVgvTDWffmVs2vFitjUv2a3Xo+ByCE0GqR8TYFJYcQKqgisseYo8h2FGrKuNRo2WfFnDMZuPXIqRGRPcY8RfbNWTFXUCsFlNciputx2V5YO8FdSTS9i8gGyDyyb27rP6xKuVWlErU2R8sOTtfJ1nIR2QDZRzZfgwuqV6Mprs5KAUVM40ipuBv4gppMtohsgDmI7MhYH03S/N4sHPGaEt6giciORTxBS8PKyot6Yx7/s4zJiGfjaVhZefFq7fXC+RaRnYaVlRcAsHC+RWSngcuGRfMdIfvx3gR6ZpHNWSDfT/1aUu9ZvJPklw2L4zssO9vRLAoh2bAgvoXsNIzLhkXwLWSnIVK2ZQ/n3LeQnYZI2QDQ6/1vnn1z2aN/lVjITkicbADodo259S1kp2GCbAB49+7i1drrJxtMcoTsNPhlf/rU55lXa6/9KaOhTULIToMr+9On/hdfrBz+/Z8AsPb1H6uH/8h0XA8gZKeBy+am6w325Ze/A4B37y54Zm4RstOwsvLCNQ0A33z73Y8/NnhmnoNbyE7Dq7XXrmkAqDfYy5cSALx92/7qq99nOrRJCNmz4Ztvv3v7tg0AGP8h67HEImTPhvfvP7x8KRX+9OfT01+yHkssw+EQ3d31B4PBYDD46ef/DAIMl5bBYOheBdu2bdu2LNuyLMuy+v1+v9+/u+vfRcOP93lj22Eerqlt2/8HFExEVrjMPCIAAAAASUVORK5CYII=” alt=””]

As expected, I received just “Muller” which is quite normal as “Muller” in German speaking is not “Müller”…
Let’s try with:

Select name from Person where name like 'müller' collate German_PhoneBook_CI_AI

[img64 src=”data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAJAAAABPCAIAAACLTNsVAAAezUlEQVR4nO2dd3BUV76gqdqq3dqtfbt/bNVu7bzdV+t58+Z5xh6bLByQ8dgGmwFMRoiMMiCEhBBKKIdWFhICRZQDykJqqVsZ5ZxjK9FSp9s3h87d9+wfLZIRGGnalmH46leqvveec3T79/Xpc3NvoBUqtUar1mhVGq1KrVWqtApjKDXMSqFQahRKjVJlDLXqtbFWNGrN69BqtTTNDA0Ni8VisUQiFkvEYolILBaJng/Rkki0JHpTln6GN25oFYhfBoIg/DmIFyFJcoNaowVvISqVqrKyksfj1T6hrq6uoaGhoaGh8TkaGhpq3x54PB6Xy0UQhKIo4hW8IAxjNKNCfEyIjQmxMRE2JcamJdj4ItY59iw6xgic1q2jKiMKhaK2thbDMJIkjR89GIaEwsezs7MCgWBmZmZmZmZ2ZkYkXDQW+O1DkiSCIDweTy6Xv6mw6gHxmXtDN4rmXQvnXZPmL8bPWyXNn4mbN78+b3593tx1fteN+T+cH+T3oeuoyshPhCkUTG/veGtrT19fX3d3d39P90BvD5fHzamqZBjmV0z72jEK4/P5qxBWMyS5eH/yFhfyqoR8UpAzUfJdHtAud/keH/QbT+gbT+iHQPhTy9n6VuKlBCoXeyvjI0L8jQRy+FMkuyoDLDzU0d0voFclDEVRgiBwHFcqqerqqfHx5U8SBQABQFXvbEh6qYKm8bcBgiBgGF6dsNYBSdSD0eJOYUmnMLlmoLB9NqFMGJ4j8L7bE18ijC9Z9Eqc2Pplfm3N3EsJFOZ5nfzLxn129vb29vb2J7/cd714htSsQpihJ/DKzaCE0lp+54SIekNhCILgOI5hmEJBVtdMzkxhWrVySfS4fwGqntGF3hsMDylVKCjsdaAoRiq0LABahsRRFMVwUqUHQKckXlvN5OA4LpfLVyest1s83C8zvp6dHAVACwAABsXUWI9x5twUtm/v5eoa3ksJnM3kBPokTjyZ7HM3dysdh1chDIxEuoUmpcZcvhxR3v/zFV8WVl8rKHw02dTTUZjf/OBB+f0HtSEB2SHBJVoVxRAESeAYhqEo+lKeKCUxU5foY+Nx79G0XKOgMGSmItrNM65qDsUJ/LctbHBwur6+QygUjo2Ntba2Dg4Ojo6O9vf3PHxY39g42dHeWFY6cPCgPY/38KUEzmVx/D3jBpandPVXd/vUzmMqYZXroQMHDvzoHF4hBgCIG8KuHT6w/8ebBb3S2dake/USLQAA7amtLC7Oj4kIvHjgmx1//tMWizujsFLUGHr0wI8/XnQtnFihpxqFyeVyFEURBKFpnM+b4nXOzYtFswJkdnZBIBDkcHsKKzp5k1Dp5OjI0mMSR42FX4BQ6JGOMOtPNvyXvXeqBVpWBY+k7f6nDf/5C79+jCDxJ8aMFZ/6RlEEeWofRZ9f9KzsT+Y8m16efFr9SXmZTLZaYYPt7e0kScIw3N3dLRQKYVguECwWFfULpoQjc4sVTcOHD1rU1FS/lEBxedDpD/91865du3bt2vX1Zxc4NeMYM1d047xbbEFBQfxNp1ux1Y11IX6ONr4ZeW77P3NNyw86aJEwqQIALBZE+bu5R0RERdxycTi2/5TznUYR1hP514u+mff8bE4ePV8kegNhNTWTvV0LGjWjVimEItAo0PMmlJRCNY+rm8ZEtleTS4v5KhX9U2c4o5O3RHi5frvxbxFF1fO0DuG5mZl/bXYgZhjFSZLAcQzDcRzHMBTFng03GIpiOEHgGE4QBI6hT3TgOE4QOIo+WYw9KbBcebkx43Icx3CCwHEMXaOwnp6Frq4F4+uBoUGGYQAAEIQ21ndijGpcCRoHBYd/PFBTU/NSAh8XhLhY2t2uraurqyvz+G6TR+mwZDxv3//8Xx+b7969+6tP/vjv+92Ts2M99v/ps2NRhR1tgrmuBItzydNqAICo7G6En39MaGhsSlqCm9sd3jgJwGTozj9/duBoUOHgxPCSciVhfD4fgiAEQWAYpiiMx5tubBwfHR3s6ux81Nybx20umxECjAAVKeP5BYn32+3sQ0pLGigSN1ZZBqO1UHPQdX9f27NXEnNqx7Hu8FNXAh33W6YIsMcdWR7fme3YYWbuEPFwhtEulAcc+Hr7ti2fOaQNoMKRHM8DZmbbdhx3LR5RzZZ7nvjGbIeZ2Y4vvwqqFNKUtCfX45uNmzdv3rTpi/OxPIFS3uB3Yo/Zjh1ffGefO0ZQwv60G3vNzLZ9ZulZ2g+rKAxBEKlUusoxrHeovLx6bGysr6+voKu3prm9smKIV9OcmdlbUNxbUMbNLyo7fOgIj8d/KYGzWRx/z/hB44S+LeC7m5ltldFH/nQuuXdscnJiZGBgYkYkkc6PD44+vH3x8K6LiSURJ8/cXwAAAPnDu2Fe/jEcTszdhKhrztEVgzBgmcXx/qHO6gCLnRaOeY9f2uI0CpPJZDAMy+VykkS43MnhYalSqSBpRsGQizBUKpgEahWYn1AJH0cW5X7y9bkvPnfs6R2laUL+FJTSyBoDnDw5YQGXHENSK3P97PwzU7wtbO7W1aV7HD3smVHDzwuwPHIlqqww4sCFa34xaQnulocCs4rjbbdevMtPuXHU2iW0bgGfbKkqLSnMTw213n8+qb457eYRc9eMvsGmexcPW3mlcYv9L9q6BGcUlyT62x+yiy3Ji7HZbp1Yl3ztRxu3yLolLY3DsEQieZP9sGcjRFdXZ1tbq16v1+u1FdWjj4VSklJMCeYKyhu6BVpejyqL27pvr211dfdLwmbSAz2cQlsMy5Pd3l9eSuaXRtnuCS5fXFoayPMNDeckxftdvuyd2zPSFHLcIrwo9cZOt5zhqanxap/Ltuf8okICwm/fjXa29YwvHIBmSxz3nE9on6xL8XE8d6td8SbCJiYmEAD0c4ROSii7IVXJ5DzAFkCKH2gbLBu97x0ftcc6sK6jg6HInwq74up/vzLXwyfK49Bm9/Tq/HCrC6HZ8bYf/tfffWS2w2zbpj9/uN0xqSjp5qldmzYfupXe3Dk11vfAacemLftPB6U1T84uyabLPY/u3rp9++aPP/zo+5upqd7HziXOagGg2oOdvUOjwi5/u+mf//Dx1h1mWzZ+tG3P5aSKHKcdm7YcPM/JaJkUCGU4gqxJWFdHRwfL6lQq9lFz/+MFGUqSHQJReVlTS5+2sBd/wG8/sO8ql9v7krClh6l3ItMHnwiDym8eia6fly5UumzZvHnzpoMOCUNKlWooy3bfxs3bzU5FNyAKzUiy1ZbNmzd/abbliGtGRl5qUnpeU0OB28kvNl0qmxX1pNls2rRl2/en4ltQ/St6mFQqlcvlEAThOMzljo+Pw3q9SgRjwzjbOgVKK2YBw4DhHsPSgkA4XDTetvdcYB2vg6YJ6CkIqZY1Blxx8Ununed7HNz0ocW99k7enfPngtLCHb///BoPoQn5/OCj9p6+vq6O7uHJmcJbP+zccj69r7enb3asM9th+8YL4eGeJ87d8K+YoakZHufgcd+UZK8Tp6PG1QAou0JcvEOiwy7vOuSS3CCkCOnscFtt+8BIb1fP7GjbfavNH5/yL51WKQi5XCwWr05Yf38/hxMaGXnH3T3JxSXf1fX+zZthnl6e7u6RLi5JLi5O7u43duw4VFXV+pKwV2PQ6/XPJ9zw/KRB/5OlAADWYDCwT5caVt7/NgqTSCQQBMlkMgyTc7njk5OowaCcwNg+iaHwUXspdwwsSQwcbwUvv6QrLaY2bf9JTm1NO0XhsqfApFpS62ntcD3mEY7U+Vr4FXSMDNaG7j8SXd+W7nt2t3N0Da8w2Gbf1cjEe25Hvj96LSIxieN8yio03P3A9v0+BYUh9lZeMeFBp50dnYJyKosSnX74398H8dqy/U58diG47GFu0Kn9Vr4Z9dy7lhdtfJLyS5L9r549wbmf7LbP7KB/YVGg9RnXkJwRWIHDkEgk4vF4MAy/qTCRSBQRwbGz83dy8rp6NdTJycPRMczZ2fnaNa+rV0NdnJ1cnJ0vX740Nja6CmG/DCsKGx2SSCVEp0jdMA37dDqV13ABCYPWYqz3UUlD0Z0U7v69IbW1LwqTo5SkJyMuIaWkR0aTOIETiGSqLcfXv3iGgSbq7lmb79y58zvneO4srRfyIk7u/eqrXT94FE0SS+PFwRZfmZvvtgviTqiI7jSH47vMd+403/XdUbe8OQKebU2xOXzk+B6z3/37bufsQS2YzrA/sWvnzq/3XyuaxMnFoVy/Y1+Zm/9wJZw/jjIoJINWL+wtwihMLBbLZDKpVIqiEJ8n8I3Jc/W6fTH67pmURLu7qTWNLQCXLnLsBEUZAWkZIXfvHz8SyOO1kSQmfYpEIpFCKIahCCSRSKQyqVQqlckRAkdkEikEYyRD0zRNYLBMKpHBOEUzDEMTCCSVQQhOMTRNkzgMSaRylKQYmqYZRqFSIgsjdal+gSERMXfcz+6x8UpoFSpxFCUpmqZpmkAgqVQGoQT9pLpUIpHIZLKlpaV3VphSqeTz+SKRyJhzCJKOjSxFZZdF3osLTkr0Tk4OTElOSc4MjCg/5lty5MrdsxbJ1hfDNm48w+N1kCQmeXOeaF1xcoVlUhmMSgS9xf6WlpaWJy1OW3EyGmZRUi5dubb0uYnFxcWfF6Z5m4VJpVIYhpe3HlC5kiaVCoWKYbRKpZIiGxraQkIyo8NzYqLyY2LzoqML4uKKp6bmMAyFfmFglFTpl1EzBALJfr4KDIvFYj6fj+O4SqVSrARN02+rMJVKVVZW9vSk5UvUNzQ0tLW19vV1vhhdzc1N9fX1r6i1ztTV1RUXFzc1NbW0tDx6kebm5paWlomJiQ1a7Vt5xhkAAEGypaVVXQbwG2dJJBJJpdIVr1BYXFxcWlqCIGjD+MRUY3NbQ2NbQ5Mpo9Gkra3Yfmtbd2v7P0q0tHW3tfdMTc9sGBgclcsRGEFhGDFhzC3BMsiUDa45EAQRSuAlGYqi+NsdGE4Q5IaR0QmWXd3J4TcBV7J6w88X+3VgNKxy/S9DMQF6vX7DyOiETqczGAx6k4LQOo1Wb+JG1wRr0JNKHa3+zXx8/g60Wu2G4ffC3h7eC3vL+NWE/fQfsz+dtfIg+tOaa1qT98LeiGfCDAaDAZ0aGeeXFmfFu7t7+BR0LaoBmK4O8/Fwd3f3DL5bME9pZkc6i+/fi/Hzjqvray9KCPX1ze9HAADkbEO0h7u7u28mf5wBgF39ar5zwkZ+YWEsAEBYcMty2ye7r/ldu3bph73W9zoWqOnqiMDAwMDAGzbWthFZtakeZz7fetTN5cSX5kcd7Bwdz37zzdXSBdFkRYCd7c3AwMDLVleiSgdlALDsP7AwnU73qwhjFwv9zh61T5cDAEDb1VO+D7plgJ1Kuenk4HBu/9f7T7tF3/FzvhLUCcCU9wGbuHqJDubano3hVoR+/38/+O68g4PDkU8/+PBHj0oEALBKY++FrUHYbG5U0I3IThYAAFc7Xgguaq/NtLe67B6XmhrnZmvj4B5zO4bjnzQGwKNrVpzSPjE1l2d1PqI45Yb5708EpKempqTnPihuG1uiDKte0/fC1iIsJ+yWY1CTBgCAcK+cC8ptzHT9+HKJBABA1yV4HHGJvB0R6BU/CMCjq2f8CzqXyJmss+fu1NUnXT90vAQGAGB1UYlJeQMU+/4r8dcQNl8QHega1qIBACA1zjZh5T2Cjlirbdu3bN36yR/+3/YT/vcSb3P8E4cBaLthE1rcIyJnc8+fT51Wy0cfeh7809atWz/927noJiGuA6te0ffCVilMr9frNRSOIbhCr9frtQwixxmVXqeUCSbGxsbGpwRCOUaSBI4RKr1eicAYrdTo1JQcIjUAsDp6aWJsbGxyCWEMAKxhLd8LeyNeFGZMFqvXP7mohjWslD92+Xoc1mCsYXjxGpy1reK7J2xcr9exrMFg0JswEFqn1elZk7a5tgCsnnqXhA2NjCvUepWWVWoMpgs9TBsAAMYOYzxcwT45nmGc1LEAAGA8hv40ly8X0D83/2nJ5brPFVix7tMD9GoAKNW7ImxweBzClRChgnClqUJOqsUwlZb9YGBMkFtU0dk/VlpVV/eoq+5RV2llbWf/WG5RxcCYIKugtG94Kr+ksq17qJLfVF3f2tTe96CsumdoMvtB+cDYTHZBWffgRFFFTVN7H6+xraKmsa17KK+4sm9kOqugrH9UkFtU0dE3WlpVV9vcUd/SXVJZ2zUwnlNY3j+63HhBKbela7DoYa1aa/pTSL8+Op1uw9DwGEngKqVCoWBMFWqVSg5BwaGc1rYO/8CgGn7t7bg7OXn5OXn5Mbfjavi1AYHBj1rabvn6NTY9Cg7hVFRW3UtKTr2fXlRcGhYeWd/Q5Osf0NLa5uPnX1vfEBEZXVRcmp6ZlXAvsaKyKig4tKm5xcfXv7mlNSAwmFvDux13JysnN6/gQUxsHK+2zi8gsLmldbnx0DAen5+VlbneqTYNOp1uw9DQKEVRLMsaTAfLsgiChEVEL4jlagPAaA2tNhBKHaHU0WoDRmsYLUAplUILUErNaADOaCiVgVTpcYWW1rAorVY8KYDRalrD4gotqdRTKgPOaBgNQCn1cl0twJgnjSt0tJp90vhyAQMAlTW1RUWF651q0/BM2IpbiWvedDQYDCiK3k1KnV+SwYRChlLPAqMhjH46CWE0hL2w9Mn8Z3//nsAV6vqmFi63ar1TbRp0Ot2GwZWEGQxPLhtYkzOWZWEYdnXzECyIEFL5NH1SlMEUelqphjFKilAyTImrDCSjlCGUnFQhpBKhVAipgDAFzqgQUoUzSujvE0aptQ+Ky5KTk9Y50ybiVcIMLAA69VC6XWKriNCzqz6nYTAYMAwrLK14LJbLcWY5fbiGggcTHI99cTGuZY5g1BrRfHvw+R/PhvLFWlV3fvKd5PvJt+OSHjSPCZqC/dIrqjK8g8rHEVr+XI9cbaC0srOnv729bb1TbRpWFMayrKI13vbbrf/2P/6jZcESya5+j5VlWblcbmNrPzW3+KyHEXqltP7q8c3/9LvzD7olCoNaUOv/hw3/6V8tMxb0+qXpib6h8f6BsZFZqXA4/dgBr8QU733H4vtgGqFUKK3GaDVCMDKUhkklQqlRSil/A2GMVpeRnRcVFbneqTYNKwozGAw6UjI71J1m99G10nl0DQeEDAYDjuNcXt2iFHnWwwidQsJ3tve2/Ov+sLr+RUwxkW/z8TfHD1lljxOkGGFQRo1RSilCCQfun7YISMsIPHY2eQhl5DA0MSkYnpifkxBynBSK5XNzc2PTIiHy88IQStk/NDow0L/eqTYNr/xKBAAAtiNg643SWUS/ph4GQdD5C1aTs8LnephOIeE7WQXGetmcS6huG12s9Dp+KTjA2i4iIZHjElQnZllmscbZPiwtI/zceU56RuCx8xkT8HxN3JWd27/43OzzM4FVo7MN1y/aHTLfsvOvXhWLuJxkXj/IMVpdWkZOWBhnvVNtGl43hmkUTbc2u65NmHEMq+DyhBL4xR7Gc7roG58aY28VllWTdtU6POM+x9Y+NCrS29q9SgyAQlhudfJWQkrouQuc9Izg03YpVQ/v2O3ZfzOTy80LPPDd+VvhASfND19PaZuQvtEYhlDK3oHh3t6e9U61afilhBnHMIdLV14cw3QKCe/qBe+4hx2Frk7uboc/DyrnZkfZ2oZEx/jY+fCkACiWqi6d9U9M5Zy7wEnP4pyzjsqIsfvjf/vjtq/NP//8q13fWQTG+R0+GVbYtYRrtW8yhtEaXVZuQWxszHqn2jT8sj0sO+/BC1uJhE4h4Tme94p/KJiudPz8j+ZevOn6wljrS2G3w3wuOfMwAIC08swpr9jUsPMXOOmZoWdtb2fGuh761r0NAAA0w4197fx7p84E5rUuwErVm2zxY4yqtaO7ublpfRNtKl4rjKl1+cChYBpeWw+DYdjrlt/MY/GzHWdCrxRXWh1xCisclcu6Ym7kd4vna7N9D9qk1JUk2u06aB8SEuR69INtttFpQceP+SYlee2zSG6fqIq+/MNJO06Yn/Wh727Ep4UfOu6d2TQHq95IGKnSFpdVpqffX+9Um4ZXCjOwrFY9WxvPHYWZte2HIQgSFRs3tyh9JgxX4dBYQXZlbe+iXGlQGABNoiOdvNSCEal8uujO9XNnL5y+4eETUd7d3ZiZU9fSzkvJ6ljUquf7K/0uXjh97kps5bgUE+Td57ZNyuSU4k2EEUp1TW1DaWnJeqfaNLzySIde/+Sk45rOGhoPTcXfTXzx0BQpxVSURo9TjAwhZSglRWmE1jFqFYSpKB3QAaBjgUZvQGktrdFhtI7RaCCEgmmDCgAdAAqVGsJUtEaPEYzsDbbpZSiFK9S1Dc0PH1asb6JNxWuF/R0YvxJvenj/5NDUrx+UWltYUpGamrLeqTYNz4SxBoNBrzdVsAYDhmEFxWWLMhQmFHKcgTBajjNPX6z0l4FeW+C1dV9ZAGPUXb0Dra0t651q07B8tB4nKITRI7TOVIErWYkMumhtMzI5K8eZJRkqluMiCBNBmFiOL8lQCUw8/9c431jm5QLP1xVB2Ip1X9U4qdIkp2VERISvd6pNw3IPw3ECJ2mMoEwVOEnTNF1VVWVpeaqKW+3s4pKRmcUJC+eEhWdlZzu7uFRWVdnY2PL5tQ4Ol8rKy909PBOTkuPi4/38AwqLii9fcayu4Vnb2NTweI6OVwsKHvj5B8TExKakpLp7eFZUPLSzd+Dx+Ta2dpVVVdddb2RkZkVERIaEhmbn5Dhdc+Zyq21s7YyNl1dUHD12bGFhYb1TbRqMwkYoitLrdTqd1oRhfHSfVCplGBqCIJIkURRFUZQkSQiCGIaRSqUKhUImk9E0LZfLCQLHMQxBYJqiZDKZYrkAA8lkFEUhCIxhGEEQcrmcoWmZVKpQMFKplGEY+dPGEeTlximKkkgkhhWv0XoLeSbM5Je50TT9S9yJuwYMBoNS+fIDF99KXins+UJrFvYb+Vyr1ep3XBgLgFbYWpZ9P+1+TsUoBgC7hu63sjCWELTXlrdO4BoAAGB1xFRHXcuI5OduGGeWZmdnZuenp2YeS5nVvsl3XJjBwGoetwZc++H7PfsP7t+19bhrr0i3hhvpVham6fb6279s+MDx0WMtAICZztnz3//D7y/kkz+zntOpgQF+gWHuN/xvF02t9k2+48JYllWMFAfn1S3pAABI+fUvrXMW9Oyqja0sTNXh63L5602nSkaWWACwBrff/8u2by+Xq35mPQWZYWGh4bF+tzj3yqZX+ybfcWF6/XOP19CIy93MbXNNKKzV60p0xKWT3rwBiDTMpFkedbt16Wp6a09TVeOcAQCgnnlY1DgqUgLNyL3rDtbWNu7hDyEgKYgMCw2P9fPhJD5cAGA+18/Z2tr6qnfWnE63NNGWFhfp7+CaVDOjXulNvvvC9PrlexLE/Fu7vj1dMa9ew2UdrxLmeSk0N8X/om/uo/G+LKebydkx167F3Iu7ZetVpwMAkFyb4945beNdKW4unhEJCVFerr5xuZWZd6LCwmP9fCKSa8aGCv3dbgTEJyQEuXsEplRXxDuY/fmAe9id8q6lFZ+a9Q8gzMACAOCmqB8PW3H4s+o1bXW8UphDcAafn3g5ICPX/QfP/Eelcc5OMWnJoS7BzToAAFXvYhNWWJlmv+2Pn3570MLiyNdbP/rim7PXOQkxkbH+frHpBdme33/60RffH7ew2LvzL3/Zctwr+Jb11bLXfKm++8IAAFhr/NETNhye8TdWVnvP42uEtXjYB2Q+WhRkOVge3HWheLK/6t61q9GpiSEuIa0AAKBsum7LycsNs/jkhEd6UXV1Db+2oWeg5nZoVHhErL//7fT7UbafHb8clcmtrubx6zu66rPuchz9Gl+znfmOCzMAYBDkW2zeY3mnXkoxNI5TSq3phDXfsPJJaxDphBmWWxwrF2WD1XG2bskVaTFu51KncBwfTtpzyC35UVOy7e4grphl1eNlGeE3I0PuRHJCom55hSVVNOU47/XM6FewrLS1IORyVNz9QHsP3oqjl5F3XBgA4HGZ0xcf/J9/+8vGzZs2frrja/eyBZZd9UnMlYWpO4OuR+Q+WgRAg0kpLaDGeHev+jZgknaO5baPN27cuPvL7Xv9G2cINfHQzWzbxo2ffPk3j7qp8aKkhLj4pPDQ+My6RQ3dGrLH/JONG7ea2xf2TdTm33YLaXrNQzrfcWF6vV6jIAkMlsukYrFYLJFitMZkPQzo1Sq1Rvdsvl6rVqr0ALBqBoVkMhmKkbTKWE+JymUyGUKoAAB64w9jqtUaHQsA0BAIJJPJMYYFwKBVK9Wv2/N+94X99Enxa3j6zPtDU78Mz05gAlPfMvte2C/B8glMkqQUGpZRG0wYFPVbOVqvVqsVipd+u+XtRKfTbRgeHkUxHCIUEG7KwHBCpVSqfgMolcq390HUP2H5KQIqlVKjVqlNHGpjstadd8YWMAobGRlf79V4z5tiFPaLPKT5Pb8E74W9ZbwX9pah0+k2LCwsqjXP0L4Onal47X9ZAyZbsd84Go3m/wPjs3poEaw0iwAAAABJRU5ErkJggg==” alt=””]

This result is consistent with the German speaking where “Mueller” and “Müller” are the same. But I cannot yet get my three forms of “Muller”…

Getting the result excepted by my customer seems like an impossible task by just changing the column collation.

Another possibility is to use the SOUNDEX string function. This function converts an alphanumeric string to a four-character code based on how the string sounds when spoken. So, let’s try with those queries:

select * from Person where soundex(Name) like soundex('muller')
select soundex('muller'), soundex('müller'), soundex('mueller')

[img64 src=”data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAXYAAADLCAIAAAD1Hy8tAAAWDElEQVR4nO2dX2/bRrqHxx/HV6cJJQNk7vrfH8B3Vbxqq0nrT7GRG8DAaWhdBdBFW+8269SoCiwsVFcHOMYuFkeNeeoCvbBQwVc5bR3ZTqzsbmubgnkuZjgcShTFvyIt/R4MHHJIjqix+Pidl9SENJr//cnmlw9qj5/9/Ov//XL886/Pfznu/fr85Pj5yfPeae/k7OT07OT0xcnpi5OzF6dnL33K2dnLsxe8vJhUXr54mTTnUvHgxUv5BG4eATvBnz4A04V8svnlorpSXF6b8NkEAICQcMUUl9eKy2uN2SXrfgZgThlWjDWLQDEAZMW8KGZ+yPoTBYALVy6mMbuKybqfp8T8vFNwUwgaxdC64VkUOlym6Y6ANBqNoZsue3t7e3t7u262th7Hu5+VPVAMyBshFFM3LF7qFh1Tbopi6vXh8+z1erRez8QLCQLFgLwRPYoZjV8UaijKGMV0N1XigrYi2aK7qaqb3ZAHNRqNoQdMhGL6/b5xahmn1vbTc0rrmTztkiBQDMgbQXMx8p/9/f19sby3t8cWLi4u6nVDUWggNUQyhXNgyMPHKebw8NAwjP39/e2n5/W6AcUAkDhBoxhZMUIrlmXt7u5alnVxcdHv9+t1Q1VVPzU46y0aLY6JqpgzN/W6UTeM3d3det3Y2nrMCqX1s4AYnxQIIas7rvXCJ0bQ49MCigF5I6hitrYeHx4e7u/v77lhVynLlYZQjFh1BlB8s6hQN7uuoxy5UKo6R7j2H6+YUzejuZjtp+c8nDGMumEcHR2d+vB0vVAoFArrT8UqIUSsZgcUA3JIUMWIZTmKqdcN9jUE49Ta2nrspxiPVIykEL5oRzfdTZXQlrdi5CjGvX8YxTx79qzX6/V6PcOwtp+ebz89l9+UolA/yzxdLxTW1+/aUvnqbuHu3QIUA4AXoXMxcv5ld3dXZEwnKMYJM2wfDHuHycMd0kxQjHv/8Yo5cVOvG0dHR65YzDDY+7TqtF439vf3mWVOPPluvVBY/+6ru4X1705OTr66W1j/ar3AVr5bL/C3w9adiqHt9rHO+7/71YnrgNFjxrQpgGJADgkUxTx69MgwDHZBiiwG+ynSGfV6PehAiQUf40OPFiUkUBTj3n+8YnpuRgdKXDGWZVnW0dGRQqmiUEWhPU/a1UKh2mY/e09KzjL/x9mn96RESk/YKik9GV4daVPeELRNBygG5JCginGuxrrB8rv9fn9r67FxarGxxqNHj4LeURp1jBgZEZGkUTe7Ula4RcmoYob3D6cYFn/1ej3j1FZMnVqUWpZF60q9bijUVzG9drVQesKudyEdV1zmVEmSkFdFhbS72Ba0TSgG5JrQimGDI5F/EbmMMIoRcmlRn3SvKx2sSnJhR7kGW/7p3uduhGKYX4xT10iw3+8fHR3VDUNR6HNP2lVFqbbZv4pSemLXtKsKKT3xOuJJiRBpk736pESUaltq027ZVROszefPn0MxIIcEysU8evRI3D+SB0fsRtIjm7GKyZRGo3HshglF+MUwbMVQalHl2bNntK4wxRx70r6vKPfbbIGUtp0asW5vat9XiNhVub/tXm1vl+zdj7dLZLSFIG22nfOCYkAOCRrFqKqqKHTop7zAmJo4gjNBMYZFDUXcMuv1eoeHh3t7e+y+0gTFeNRsl3jcxdfb9xV5fdyqd1WwNqEYkGfmYjKHX92we0bsATxWuGKoYlFlf39foQpTzK8Z8pf3yHt/CXUEFANyyFwo5hc3LJW7urqqUMoKUwx/9M4eCSoK/WXaPH5Pimr++I9wB0MxIIfMxXwxEy9OJpTREs0TWQHFgBwyF1HMz/MBFANyyFwoBgCQCd9///3sKwYAkBUXFxfeuZivv2mioKCgxCwHP/zoHcV8/U1zkCbHfTPV9iOTyIkd980s/mAAkDsuLy+hGBdQDAAJAsUMA8UAkCBcMZ65mPhXmv9FmGr7kYFiAEiQPEUxHV0lqt6RVqW1qTFZMQFODIoBgHF1dZUrxRBHMjlRzOhpQDEABCZnilF1vUIqTWc1e8WMAsUAEBiumFzkYtilKy5ge6FZcb4XWGmy+kqFTdmrN3W+0OEt2BNYRZbT2CjGaXxy81AMAIzcRTHMKbZKvEYoImUjL6h6Rz4gRgQ0RjEdXbXDq2YFigEgIKZp5k4xg0GzMhTOyOHDSJgjqUcmomO8FSM7CwMlAAKTT8XYgyFV78gxw5iRlKSYSvyThmIASBCumBzlYvhKs8IDkabI/3LbjFOMPJaJoZuJA6Whe+vjGsnwlwpAfshpFDNwZ1pIkIHSYCClhtNM96oqohgAApInxeQDPN0LQIIwxfwZihFAMQAkiGmaZH3zz7nIxeQDKAaABOGKQRQjgGIASBA/xRz3TZTIJcNfKgD5wU8xqc9LTkhuf8Ykw98oALnCLxdzfn4ef8gwjvPz8+OzVzks8QUBxQAgmBDFpKoYQkjmQhkthJCYfQrFACDIUjGZ2wRRDABpgygGUQwAKRItFyN9byiGYrwvcmOjQAhZbdg1B9UiIcWNtueexY02+zm9KKZFCW357gHFACAIG8WIL+okoBjvKMbYKBSXHGsw40xRMeOjmG5NY+8digEgKNEGSilHMcWN6upS1Xh1fPbqeKdcWC17SwRRDAC5J0vFjI9iNto75cKDg+OzV9urS9WdEZXIchH1LN4hhJClqsH2KZeKhJDydjJRDAOKASAEuczFOOJolEZV4q2Yg2rRDnxEPbFrEMUAkBF5jWLODqrF8vZOmaw2PAZEo4pxQhg7kNmJOIBCFANAgjDF/Km4/HFx+eMcRTFnr9oPlgrFpdKOV87FWzHuAVHUHA2iGAASJEvF+EYxLLdS3nZqGiUhkZ0y8RgokdKO3QIpb0dVDKIYABKEK2ZRXclbFOMZ1/BhELurPRzdNErD6V5EMQBkjIhi1orvBldMAuDpXgDmAVsx7348fcVkbpNIUcxkoBgABFkqBlEMADOPk4spIIpBFANA0ji5GE/FpDfvJKIYAOYBrpjCux97KiZt8jCHZuKzap5DMQDYTFBMqgOlDN+2D/FPLLdvDYDpk2UuJsO37QMUA0CCTMjFQDGZtADAzICB0jBQDAAJEloxzYr9ZeZ4XyEYex2yueWcZ/S7NY0Qrdbly1qty34OryWFjyBa1H7vvl8hgGIAEITLxXR01TaLtJi4YjTNsQYzjqdEpquYbk2zzSIthmkBgDkkei6mo6uq3klHMbUatbXRohql3hKZehQz9MpxWgBgThADpY8K734URjGpRjG1bos7pkW1WmtEJbJcRL2YvZuIYRSl2qRRzQgBBIEoBoCgRFRMR1dJnBhmomK4OFp0VCWWp2KkzaLee3w1gYmCmNgwFAOAQM7FBFVMfL9MVozVrWm0xeZmCaIYJ4SxA5lWxAGUvyCCiAuKAUAg52ICKSYRvwRQDE/70pZXzsVbMe6xS9QcjY8gAgZGUAwAgpADpWYl/n/SFlAxTsZDDJqERFqUeAyU3Dd8EldMiwZM60AxAAjCKcZ5KIYQQmJFM5MVM1Ij5XM1j3Sv89iK9NRM+B4Zd2LOQzHOa4RrAYA5JEouJhFyex3i6V4AEiR0LgaKmUILAMwMpmmSdf1PhXc+KrwDxVgWFANAokAxw0AxACQIV8yiuuKpmFQn1szwbfsAxQCQIFwxxeU1T8WAaGT4GwUgV2CgNEz8E8vtWwNg+kAxw0AxACTIhFwMFJNJCwDMDBNyMVBMJi0AMDMwxWwV3rlXeOdeqIk1Y35Vaex16Dex5iSSmKTKRxDiOwT+X1WCYgAQhFRMs2J/MalZiScZP8UEnFjT+9jUFMO+e8mX/CQDxQAgME2TVPWtRXVFCRbF2MScVzOJiTXHHJteFON+mTgtADAvcMUUl9fCKSbuvJpJTKxpeU6mGXeqzcmCmDCvJhQDgANXjPLOveCK6ehqurmYgBNrek6mGXuqTX9BDGeKwrcAwFwRRTHCMylODx5wYk3PyTTjTbUZbKCE6cEBCETkXEy6/8lJ0Ik1PSfTjDfVZhBB4D85ASAg4XIx0/qv2oJNrDluMs14U22OOzH8V20ARCD0QEk8FxNzjvDJihmpGZ5Y07K8J9OMN9VmkOdi/JuBYgAQRM7FxCW31yGe7gUgQaLnYqCY9FoAYGaI+lwMFJNmCwDMDPZA6e17yttQjGVBMQAkygTFYGLNTFoAYGaQcjFeigERyPDXCUDekHIxI4rJ8LQAALOBGChR5W0KxQAAkgWKAQCkiJyLgWIAAAnDZ70rLq9BMQCAxOGKwUAJAJAGUAwAIEW4YpCLAQCkAXIxAIAUwUAJAJAiUAwAIEWQiwEApAhyMQCAFMFACQCQIlAMACBFnFzMbSgGAJA0Ti4GigEAJA5TzBe3367cfrsCxQAAkgWKAQCkiGmaZP3hF4vqyu23oBgAQMJwxRSX16AYAEDicMXcfqsCxQAAEgeKAQCkCHIxAIAUQS4GAJAiGCgBAFIEigEApAhyMQCAFEEuBgCQIhgoAQBSxDRNUoViAADpwBWDXAwAIA24YpCLAQCkgRgofXj7rQ+hGABAslxdXUExAIC04IpZVFegGABA4nDFFJfXoBgAQOJgoAQASJHLSygGAJAal5eXdi7mTSgGAJAwXDHF5bVRxaCgoKDELAc//Eiqn35x+80PhxRzDgAAsen3++T+p1/cevPDW1AMACBpuGIW1RUoBgCQOFwxxeW1W8jFoKCgJF0OfvjRe6D09TfNQZoc981U25950IFxQO/F5LhvhrijBMXcRNCBcUDvxSS0YkZzMVBMzkEHxgG9F5Mwirki9x9652LSPsVU25950IFxQO/FJLhirq6uyP2Hn99684Nbb36QA8U0K6TS7OgqUfWOXdfRVWktIok0kgrNCqlE6Gt0oE2zslBphjTG2N5bqDQPdXVB1Q/tHTq6puqdmEbq6JrmNJknmnSh0jRDn9lNVUxHVyvNwaCjq4Q418iMXyERJYMOdAgvmfG9Zw46urZAiJDMjCsmomRCK2ZRXcmBYuxLraOrqq6L627mrxDbDKFAB0qE7kDv3mOi6uga7z2TtT3jihl0NjUa1jGhFVNcXsteMeKPOfs0i8+0vEAYo5+nZoW4tw3tPNSmq6ZSUQkhRNWbOl/oiKvU4/W8Njkvz2rGNes6MeeSjRDHoAMJUfVDcfbh4hjP3uNNMKewd2dKimHRDSGEVHaHj27SBWcbb0SuYIo5lETj1Nhv8+Guri4sEKI+PDQ7uqbpeoU3ytscOAcObXJentV0Nr2bNQeDzqbG9+UVg0hxTHDFmKaZl4GS8+m1l/glw1c7uupcQSOfWVHRrBD2AXHv7HOFsI+uvMDrx0QBPpsmNisf4L2IDpxGB47rPUcxpu0cvtrRNUdBbp/xCnMwGAyadEHVDw9FDd/moxiW9+lIC7x+wbGVHAF1xm8aDAadTblZs7PpLGg6VxczC68ZWgzRgbOgmMGgWREf69EPt8eRXjXy4ePq5UNCvZxHgECIf7NEZuQdowPDduBhlA4MopjBoFnR3G/cMzvjcZ17Rivjohj90JQOGScjz5eTjxJxjPrQPtx05OGoZ0HuPRHZpK6YPORivK4QO17O+xXC/vIHa9ZrSJSaYtCB4XrPrZhBR9dcvZdTxTTpgl0lVDJWMa5RF29yCorJYy7GqRWD+9hxvpz0EDsmc4UEa1Y+VWkxlVzMPHSgPWJJPhdjitoForIhRuyBkslew71jMoqRmvVRDHsXu/boyF6cl1zM0A0R+akOMhRLe/zBGp+tdH9SnUBbVROM813xu98VIp+q3Eryd5TmogMPI3bgxDtKIkgRSZKByOCq+si9ofHpXtVlEGdAo6pqYopxjZP8Bkqu1LBI96Z7RylXiol0qc0AiT8XM28k+1zMvJHyczE5ysUMBoPIj7reZFJ4ujfuKd0skn66d74kk/rTvXnKxYAwoAPjgN6LSUjFfPr5rTc+uPUGFHOTQAfGAb0Xk2QUc9w3UVBQUDxLOMUsqiujikl7Uk9CCH7G/AlAJgT0i62Y//y8uLzmqZj0Aq3z8/Pjs1cokUuoXzMYAr0XhyiKufXG+7feeH/KiiGEZH6h3txCCEnhwzMvQDFxuDGKyfwqvdEFF0kc0HtxiKKYRXUFUczNKohi4gDFxCFyLia4YhJ4vmtsFGNsFAghqw275qBaJKS40Zb22V4lhQcHfHWnzJ+btg/ZXiVDNTNZxv6auzWNEEJbrnWt1pV2aVGpokV5d9mHiAqpkVnDp/fuLBBCv72W17XaT9fOLi264FS07vHH8em319euClEze6Q6UBJfJUlAMd5RjLFRKC4VhFOYcWTFGBsFIhTTKBFS2pG8Y2zYxx5Ui0tVI3sXpFTGRjHdmqZpmlAIM46sGJdzWtQ2CfdOt2Yf6yzNHn6KYb13ba8uEJdiXM5p3VtYYCZp3VvQaj9dd2t37rBtztLsEUUxr73x/mv5iWKKG9VV2w475cJq2THO2UG1uFRaXeKK2SkPBTjHO2U5nGH2mcniF8VotRp1HKJRKrmiW9OkClc8w/eXw5lZjWN8FcN6jzmE3mGdde1sdipc8YxlWZbVurdAWyKcsRdnjYi5mOkrZnwUs9HeKTOJbK8uVXc2HMXslMlqo/2AK6b9YGloNCQ2DS3PXvGNYmrdFndMi2q1lhSOtCihLRGfdGvakEXk0GWGwxh/xbDeu7asFr3De4+pokUXaOsnu6JbuzNkETl0meEwJmIuJldRTJuPdxolZ/nV8VmjRMrbkjvaD5YKq+WClHmZH8X4RzFdrocWdZYtEZfIitEo1aTMCxRzR/TYdYveEcsWF8w134Up5o7Te99eX0MxHmQ5UPKLYs4OqsXyNhv12IpxmUVEMU7mhZR25kgxE6IYq1vTaIspxVaFyywiinEyL/K+ljXPirnu1u7QFlOKbRTZLE4Uo4nMC98Xihkip7kYLpTiUmlHlg6RKTw4OLbHU45QkIuRhaJpUtDCEr8OIspxHYdcjBCKpklBC0v8yr33E4tyXEJhVkIuRiKvuRi2QMrbco1dpPCED51EFIM7StZoomUkGpEqhEbsvXFHyZVokWpGdpE0YqdlcEdphLzmYnxrXCMgPBczxKgZ/BSD52LcjAjFVzF4LmYy0QZKCYCne2MWPN0bBzzdG4cbo5jMr9IbXXCRxAG9F4cp5GKSUQyimDgFUUwcoJg4TCEXk4xiMr9Kb3TBRRIH9F4cIijms9deL7/2enlUMenNyocoJmZBFBMHKCYOSSombUgO5qa8uT8ByIRQPmJz9362qK6MKiZUQwAAMApXTHF5DYoBACQOV4znQCnD0wIAzAZQDAAgRZCLAQCkCHIxAIAUwUAJAJAiUAwAIEWQiwEApAhyMQCAFMFACQCQIlAMACBFkIsBAKQIcjEAgBQRA6U/vPb6H6AYAECyQDEAgBQxTZP88dPPFtWV/4BiAABJY5om2fnrf32y+WX14ed/+/s/zl6cv3jZP++/+p/v/vef//zXv/79279/++2333///eLi4vLy8vLyimMCAMBELi8v/x837Z1CcjW4tgAAAABJRU5ErkJggg==” alt=””]

This string function was able to retrieve all forms of “muller” without any collation change. I saw that all version of “Muller” is converted to the same SOUNDEX code. The only problem is the utilization of indexes by this function which is not ensure.

Finally, I took a look at the FullText catalog feature which can be accent insensitive and that will include a FullText index with German language:

CREATE FULLTEXT CATALOG FTSCatalog WITH ACCENT_SENSITIVITY=OFF AS DEFAULT
CREATE FULLTEXT INDEX ON Person(name LANGUAGE German) KEY INDEX PK_Person
GO

 

After I used the following queries based on the contains clause and the Formsof predicate with the inflectional option for my different forms of Muller:

Select name from Person where contains(name,'FORMSOF(INFLECTIONAL,"muller")')
Select name from Person where contains(name,'FORMSOF(INFLECTIONAL,"müller")')
Select name from Person where contains(name,'FORMSOF(INFLECTIONAL,"mueller")')

[img64 src=”data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAJwAAAD+CAIAAABA5vtLAAAPDklEQVR4nO2dTW/byBnH5/PkZlA2IH2DfIMcVjZ88PhD7KWRd1FvCzhquzVAwAHc1pVjrHqxCwVY5GCgTSxZTL3oHmxA8CnoriK/RHJ2E8kywB5GHL6NKEricF74/PGAIUckbfKX/wxFP+SDjr7/9+s39ddv6m9O6m9OGm9OGm/qjZP66SgaTUbUnWg0TxrNuhMNEqejOHUjQs05ZE3UraOb29ubm5kjQd3y0Qeq29tb9M23+9Vq1dZR1Wq1mz19+PBBc6jZUYagCnRMmpoOKjYtZhg4GGnSiqlqtfrBr+Pj4+Pj40O/dnf3PiguL9TbOFBNyx6FaeMxoQpU0wz+np1OB5umEBIJygf19hb9bkqnhj1qYMswxkBtPcsjn3BtJj6tZ/n8s9aUG1Wr1cA1IoXa6/Wsa9u6tiunXYxNTpekqSkE9c9RUL3/tZvNJp0/Pj4mM/1+3zQtw8CxYMzExt1wys3HQT0/P7csq9lsVk67pmlpCfVFTKgUpG3bh4eHtm33+/1er2eaVj6fj4LhLtfwbF6dFWrgS6JpWqZlHR4emqa1u7tHAmMz7pfM5lc5hNDKgW8591UzsW+xM2o6qLu7e+fn581m89gvcl7IVcYUUOmi2y2PPqYN+Wct31YuTozz7ha+9cdDvfYrPKZWTrsjy1qWaVmXl5fXEWps5HK5XG6jQRcRQnRRnKaGSue9TjVNq9frkZFpd3cvCipjSPVAG806Dm49yyNcY0P1OtW//jRQ37171+l0Op2OZdmV027ltOs9KMPAUVwbG7ncxsayg/HFcm55OaccVGb32+/3Dw8P6bXGBKiulRwCQdIEl9+2E6D61x8P9cov07QuLy99/Y1lkeO0TWyaVrPZJFyvmGps5HIbjRfLuY3G1dXVi+XcxouNHFkgrkXEuVfehsDnzrbu8S+/uPJtEN5mzD6ppoO6vb1tWRY5BXQ0IlM6LJmmGbf7JQYbb68aRiiWU/3rj4fa8Svc/Y6g2rZt25eXlwbGhoENA3eYqpcMo1Qn085+0Z0f/eOu09kvouI+WUTF/eBiaJ/eD+Lu01UQ6u8nQXWP37TIlVGv19vd3bOubdKDbW9vx736DVOl/S2ig23+WctzPVXDKAw1uP50UEkf0+l0rGsHqoltjG3bxqZhmpaBI6F26iWjuE/OMMXs63vcJg8W7yJt8KxOP4u7zwio23Ghki6XjqN0TJoGKsVZwxEXSr4LqbwHJ9nK14VHXyi994tCJUSta9/40uv1Li8vTcsyDPyeKXK6yb+GUaw4LfWSgYoV1haVIkKej5zFShEZpbpnn86efS3x9vn+/Xsv1Js4UOm1rrfLJRe9247GQhWqarXa9osgpEQty4GKsY2Nd+/eYdMgUNtMnTw1jKcnZAYVK24LXXY+OnlqILqq8bTiXzypFJ3V25UiCu8hzj5P3N9raqfm83nDwIGpd4YoNVTxNQGqZWPLoJf3nU7n/Pz8+PiYXANPgMpoqRSdfpIsnzw1vMvjFtlN8fY5I1SlVa1Wf/aLXN+SWxAkRlCxYWOj2Wwa2CBQfxaovS/QF3tTbZEtqD/5RS6CVlZWDIxJEKijmw/O+GIY+Ke0tfeFx7m/eT3dxpmGGhZBGI7ZyIhStqD+LxvKFtQM6u3btzpDzaY+f/4cvKP03T+OIJSOt//5LwPqA0+1e0Ou+1dL7d4wcaf2+32AKlIAVUPxgDoYDIJ/egOoaQqgaiiAqqF4QL2/vweoIqUp1IutfH5ra210J3vt6OHh4eFozb23vXZE1llbI0lJW0dbo5mL0ebOH9NJg1rSF6rDkgC+CHya37q42MoTZt6Z/NaFd4PwtiqIB9ThcCgBVAqDzrv+Q4hApe3eGe9qapo1O1CP1pDff1FQ1/j+upyVKagOKsJ3HNQHD1U1AWcHqq/3jYT64LmoUq/vfdAWarYFUDUUQNVQAFVDpQe13RtCpBYpQe1yFkIIpmSaONEoqPw6nG632765g2jf3HW73Qg2ikFFCAk/oTIEOFXDAKdqGJI41XNXdg6o7IO0NnMIoZWq03JWWkRocbPOXHNxs06mosHME8KdSm/HJgCV7VRrM7e45HIijLWGytWp+7I4dXGztLJUsu7aN3ftg9Xcyiobmy5QuTo1bajjnbpZP1jNfX3WvrmrrCyVDkLwvDhpO/E0QggtlSyyzmpxESG0WhGNLTqy4lQHVbUYhseGelZadMxN25HTIndkxqk3Z6XF1crBKlqpMrrZMFTXpo5ZD5TpljPj1Ju7+tdLucWl4gFr7GRD9Xez6oy12XEqGSNXK25LtUixHawiRveLigfOHtBqRR2oGXJquKX+9dKocyXfeYIOrhaDF0pqQJXEqQkI7ijRkMSpyUAVfjYlCXCqhgFO1TDSdiq/7A1wKo20ncpbwvNIJJmmCpVr98vjSFQUQNVQAFVDAVQNJR6q+8j+fDcKxx5Jq1xA3soVrXIBoUK5NZovlFtkGlxSV4KhJvgcaBTUQsHlRBgzsQHUSM3S/c75coVIqOUydkDVcAFjNjaAGqkZoHJ1arlVG1Gt4UK5FoLnxUnbiaeR4+tWuVDA2N+VyymuUCvxodLXo/CCOkJVw2F4NhOq52Pazu61pZMUUOcnOhmq3SoXcG1UZyoGVNemjllrynTL4qEmQjQG1NEFE66xxk42VH83q85YKxrq0dr8adwxodqUE+2KvXXfGN0vLRtXLiBcA6gxoXrfK4fmexHKZKihFs+VUIFxoeSWjfN8i+VxtpKWaKcmJ7ijRAVQNRSnU0FeOAlQxQigaqi0oXJNZ+FxJCoqbaigFMSDqG3bgwELKqcfBkpHpDACQNVKbKgQSsfZDz8GoYoeaEDzqtfrAVTdBFA1FAOq8CEBYs5gjKnfwft+UxGPl8JGXf3yPhiu+1dFAFVD8YTKuqPE+2C47l8V8YPKvvfL+2C47l8V8YYazPvlfTBc96+KOEP9FqAKkNZQs1o/lR/U4XAoAdRM1k/VHWom66dmDWom6qdmEKr+9VOzBjUT9VO1hppV8YYKd5QECKBqKL5QvwGoIpQ21HTqhkKkCpV3Eo0Mb3oUPuVElEL9O7zvN+Xo8nygSAxUlPn3/YJTNQxwqoYhlVOhfmoyIYlToX5qkpElp2amfqokTk0S6ninZqV+aracmpH6qRlzajbqp2bMqdmon5o1p2aifmrmnBpu0a9+qlROTUBwR6ktmVOTgSr8nAoPcKqGAU7VMMQ4lV8OBzi1LcqpvCU8m0T4VABUrt0vv+NRRQBVQwFUDQVQNZQsUKF+aoKSAirUT01WUkANAIb6qXNKNqhQPzUBpQB1D+qnpiyJoEL91KTEH+qfYkGF+qkJSg6oUD81UUkBFeqnJispoCYouKNkA1QtBVA1FEDVUGKgck1n4Xc8qkgMVBBvCYAK3S9XAVQNBVA1FEDVULJAPfIXpEgealQ6yySp9mdzOaC6r7Wf92nGKKgx01nY2wLUkWbofuctFRIJNV46y5htASrR9FDnrj8QDTVWOovNTGFRKcFFIqjkBVkcx9SY6SzMFBalElwkgkrJckw8i5nOwkxhUSfBRTaofFNE46azMFNY1ElwkQJqWsnc8dJZxqWwqJPgIgXUh+SK+kyGGmoJprPYNjuFRZ0EF1mgJiW4o2SnAHUToKYurifh/v4eoAoQQNVQYqBCOgtXiYEK4ip+RG3bHgxYULn+SBBvDQYDgKqbCNS/BaBCKB1nP/wYhCp6uAHNq16vB1B1E0DVUAyowocEiDmDMaZ+B+WrUxG/Ssfsq1/eB8N1/6oIoGoonlDvAaoY8YNK7v0CVAECqBqKM9Q/AlQB0hrqxVY+v7Xlf/rK+9qmtSOyztpanqS9HW3lPflvtAJzIq9jS1H8oA6HQwmgIk/6aQANaaGv0PPO5LcuvBvM+4xP2tIdKoVB513/IUSg0nbvjHc11cyaNajuc5MuvLFQk3ljYvrKIFQHFeE7DmqSTw6kraxB9fW+kVAfkntyIG1pDTWrAqgaCqBqKICqodKGyi89H8IbqULlnUSDJChfKnzKiWgUVH7dTrfbfdmyMx5d7s+npg4VIST8tIoNcKqGAU7VMKRy6rwvJnyIcOqr8iOE0JOa09JaX0BoofycueZC+TmZisYzW0jiVHo7NgGobKe+Kj9aKLicCGNNoWbJqQvl9SeF9Vf2y5b9cgc/eoLZ2NSHKolTk4Q63qnl5zv40Zetly279KSwvhOC58VJ24mnEUKosP6KrIMfLyCEcEk0vHGRglP/Ko9THVS1x2F4bKit9QXH3LQdOS2yRgpOTRtqlFNbrfUFXNrB6EmN0c2Gobo2dcy6o0C3nDGntuznXxYeLRQe77DGTjZUfzerwlibNaeSMRKX3JbaY4ptByNG94se7zh7QLikAtTMOZXp3VHnSr7zBB1cexy8UJIdqlROTUBwR+mlZE5NBqrwcyo8wKkaBjhVwxDjVH45HODUl6KcylvCs0mETwVA5dr98jseVQRQNRRA1VAAVUPxh/qHWFDdR/bnu1E49nii6qf6686oVoMxLCmgplVBKl79VIAaqSmc6gXMr9ZbrPqpADVSw+EQ/XY6qJxrvcWpn6patdSw5IJKX4/CC2qc+qmqVUsNSyKo8xOdDDVm/VSlqqWGxR9qORbURIjGgBqvfqpS1VLDkgPq0dr8adwxoU6un6patdSwpIDqfa8cmu9FKJOhhlqC9VNVq5YalhRQExTcUbIBqpYCqBoKoGooMVC5prPwOx5VJAYqiLc4Q53yhj50v/MLoGqoFKD+BaCmLICqoWSBeuQvSJE81Kh0lklS7c/mckB1X2s/79OMUVBjprOwtwWoI83Q/c5bKiQSarx0ljHbAlSi6aHOXX8gGmqsdBabmcKiUoKLRFDJC7I4jqkx01mYKSxKJbhIBJWS5Zh4FjOdhZnCok6Ci2xQ+aaIxk1nYaawqJPgIgXUtJK546WzjEthUSfBRQqoD8kV9ZkMNdQSTGexbXYKizoJLrJATUpwR8kGqFoKoGoogKqhxECFdBauEgMVxFX8iI6FyvVHgngLoGoogKqhAKqGAqgaCqBqqOFwiP75/b9OThq9u493dx8/fvyl0Tz75ddPv3769OnT58+f+/1+v98fjHTv0TA93d8P76dWir+fZBoMBv8H3a30QHitKsMAAAAASUVORK5CYII=” alt=””]

As expected the result was consistent with the other ones as we don’t have all forms when searching for “muller”. In contrary searching for “müller” or “Mueller” gives me all the results.

In conclusion, the FullText capabilities of SQL Server is certainly the best solution as it will be also faster with a huge number of rows and give the possibility to not change the collation which could be sometimes a real nightmare but we have to use “Müller” instead of “muller” to retrieve all the expected results.

Let’s work together

Ready to operate at
the next level?

Tell us about your challenge. We’ll bring the depth, the expertise, and the Swiss precision.

Stéphane Savorgnano

Stéphane Savorgnano

Stéphane Savorgnano has more than 20 years of experience in Microsoft software development and SQL Server database solutions, specializing in SQL Server installation, performance analysis, and best practices. He holds Microsoft Certified Solutions Associate (MCSA) and Expert (MCSE) for SQL Server 2012 through 2017, MCTS, MCITP for SQL Server 2008, and ITIL V3 Foundation certifications. Prior to dbi services, he was a software engineer at Ciba Specialty Chemicals in Basel. He holds a Master's degree in Informatics from the University of Mulhouse. His industry experience covers banking and financial services, chemicals, and pharmaceuticals.View Author posts

75 posts since November 2012

Leave a Comment

Your email address will not be published. Required fields are marked *