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 “mikvah” 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.

87 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
mikvah1814347(None) 
mikvahs19162491mikvahs
mikveh18132541mikveh
mikra114610312mikra_
mikvehs19111682mikvehs
mikvos1554022mikvos
mikvot1556762mikvot
mikvoth1962142mikvoth
mitsvah1542162mitsvah
mitzvah2441782mitzvah
bimah127013273bi_mah
diktat11310693diktat
diva85920883di_va_
divan96114843di_van
divas95418583di_vas
halvah15499833halvah
hijrah1934283hijrah
ikat87626643_ik_at
invar839513_invar
kiblah1535583kiblah
kiva116516413ki_va_
kivas124614733ki_vas
kvas117015943__kvas
lekvar1333043lekvar
makar115614973mak_ar
matsah1138233matsah
matzah2035963matzah
mica86428253mi_ca_
micas96823053mi_cas
micra96214973micra_
midcap1336473midcap
midday13327503midday
midrash1335423midrash
midway15327153midway
mihrab1335523mihrab
mikado1344513mikado
mike105535293mik__e
miked125020453mik_ed
mikes115129893mik_es
miking134218463miking
mikron12318503mikron
milch124413373mi_lch
milia72719573milia_
milkman1544913milkman
milpa92111403milpa_
milpas101710273milpas
mimbar1297493mimbar
mina65136923mi_na_
minae75627723mi_nae
minas75434113mi_nas
minish115216303minish
minivan1245713minivan
minyan1138173minyan
mirth106418893mi_rth
mirza16410443mirza_
mirzas1738183mirzas
miseat82925713miseat
mishap1338873mishap
miskal123710263miskal
mislay113510683mislay
missal84314903missal
missay114112143missay
mitral81314323mitral
mitsvahs1642003mitsvahs
mitzvahs2541303mitzvahs
mollah11319453mollah
moolah11409193moolah
mullah113710733mullah
mynah13569563m_ynah
nival84915773ni_val
pika106322953pik_a_
pikas114218093pik_as
rival85216503ri_val
shivah15488543shivah
sika86021323sik_a_
sikas94617023sik_as
silva82714023silva_
silvae92811093silvae
silvan92810153silvan
silvas92912183silvas
sirrah9379753sirrah
sukkah12123733sukkah
tikka835573tikka_
tikkas934523tikkas
viva106119093vi_va_
vivas114815023vi_vas
zillah1836563zillah

Search took 7 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 Filter1786911127160.466383457.1
2DLD Change Limit112716876.03318683.2
3Display Results87870.0302900.0
 (SQL Overall)178691876.52927368.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.