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

65 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
mikvahs1916249(None) 
mikvah18143471mikvah_
mikvehs19111681mikvehs
mikveh18132542mikveh_
mikvos1554022mikv_os
mitsvahs1642002mitsvahs
mitzvahs2541302mitzvahs
bimahs13508303bi_mahs
diktats1235623diktats
divans104612393di_vans
divas95418583di_va_s
halvahs16417533halvahs
hijrahs2043443hijrahs
ikats95311153_ik_ats
invars9310003_invars
kiblahs1634153kiblahs
kivas124614733ki_va_s
kvas117015943__kva_s
kvass12507273__kvass
lekvars1432693lekvars
makars124612633mak_ars
matsahs1236563matsahs
matzahs2134483matzahs
micas96823053mi_ca_s
middays14335663middays
midrash1335423midrash
midways16386183midways
mihrabs1444203mihrabs
mikado1344513mik_ado
mikados1444683mikados
mikes115129893mik__es
mikra114610313mikra__
mikrons13428413mikrons
mikvot1556763mikv_ot
mikvoth1962143mikvoth
milpas101710273milpa_s
mimbars1397383mimbars
minas75434113mi_na_s
minivans1345413minivans
minyans1237263minyans
mirths114912993mi_rths
mirzas1738183mirza_s
miseats92815783miseats
mishaps1438713mishaps
miskals13369763miskals
mislays12349243mislays
missals93914423missals
missays124010253missays
mitsvah1542163mitsvah_
mitzvah2441783mitzvah_
mollahs12328283mollahs
moolahs12347383moolahs
mullahs12388733mullahs
mynahs14416443m_ynahs
pikas114218093pik_a_s
rivals94213183ri_vals
shivahs16375723shivahs
sikas94617023sik_a_s
silvans10308333silvans
silvas92912183silva_s
sirrahs10377303sirrahs
sukkahs1382703sukkahs
tikkas934523tikka_s
vivas114815023vi_va_s
zillahs1935383zillahs

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 Filter1786911340270.1561145455.1
2DLD Change Limit134027656.79619721.5
3Display Results65650.0302166.7
 (SQL Overall)178691656.98225593.1
 
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.