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.