Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “mazurka” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

56 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
mazurka227287(None) 
mazourka2341321mazourka
mazurkas2372381mazurkas
marka114620792ma__rka
mazourkas2441262mazourkas
mazuma1935602mazu_ma
anuria6313123_anuria
aura45836253_a_ur_a
azuki1864803_azu_ki
azure14911483_azur_e
azures15510183_azures
bazooka2242623bazooka
burka114617693__burka
datura738033datur_a
laura54116203la_ur_a
macula103013673macu_la
macumba1573043macumba
maduro936983madur_o
maduros1036303maduros
makuta1236393maku_ta
malaria9313703malaria
malarky1645433malarky
mantra84116093mantr_a
manubria1243493manubria
manure8313653manur_e
manured1039473manured
manurer938583manurer
manures9313353manures
manurial1047793manurial
maquila1844703maquila
mara67444573ma__r_a
maria75032883ma__ria
mark105138063ma__rk_
markas124717003ma__rkas
markka11416593ma_rkka
marks115933483ma__rks
mature8313473matur_e
matured10310043matured
maturer938983maturer
matures9314313matures
mazard1838763mazar_d
mazards1937703mazards
mazer165722423mazer__
mazers173917093mazer_s
mazumas2034623mazumas
mezuza1643533mezu_za
mizuna1734303mizu_na
mura65633303m__ur_a
murk105527253m__urk_
murks114821733m__urks
murky145216683m__urky
murra74519083m__urra
parka115120883pa__rka
parura8310583parur_a
taluka10426773talu_ka
yamulka1651773yamulka

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.423422437.4
2DLD Change Limit134027567.18618651.1
3Display Results56560.0331697.0
 (SQL Overall)178691567.64223382.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.