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

91 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
kwanzas234205(None) 
kwanza2232471kwanza_
bwanas1157442bwan_as
kanas95326912k_an_as
kanzus1944602k_anzus
kwachas1943062kwachas
stanzas1636362stanzas
zanzas1487052_zanzas
anas46649863__an_as
angas65827993__angas
anlas55626933__anlas
annas55824883__annas
anoas57226493__anoas
antas55432033__antas
asanas6514113asan_as
baizas173810823_baizas
bandas95120543_bandas
banzai1737653_banzai
banzais1837163_banzais
bonanzas1943113bonanzas
brazas175812433bra_zas
bwana10310243bwan_a_
cannas84518403_cannas
canvas113813333_canvas
fangas105017203_fangas
ganjas14149113_ganjas
goannas836223goannas
hamzas20119013_hamzas
hansas94616043_hansas
jnanas13207303jnan_as
kaas86531843k_a__as
kakas85117343k_a_kas
kalpas124112943k_alpas
kana85928533k_an_a_
kanakas10327213k_anakas
kanban1238623k_anban
kanbans1337723k_anbans
kanes95529373k_an_es
kanjis1735963k_anjis
kantar10311153k_antar
kantars11310033k_antars
kanzu1847593k_anz_u
kapas116021733k_a_pas
kappas144410363k_appas
karmas123013733k_armas
kashas133311903k_ashas
katas95922093k_a_tas
kavas125919953k_a_vas
khans124615173khan__s
kiangs11378363kian_gs
kinaras1159123kinaras
kinas95626913k_in_as
koalas104011663koa_las
koans95818623koan__s
kwacha1832983kwacha_
kyanizes24205283kyanizes
lianas63713383lian_as
manas76240433_man_as
mangas94122933_mangas
manias84029033_manias
mannas85019803_mannas
mantas85725363_mantas
matzas1749703_matzas
nanas55928633_nan_as
organzas1853263organzas
pandas95521963_pandas
pangas99921113_pangas
piazzas1743643piazzas
plazas17409913pla_zas
ruanas6311263ruan_as
sangas75222663_sangas
stanza1537073stanza_
swanks134811563swan_ks
swanpan1243693swanpan
swanpans1343423swanpans
swans84625013swan__s
tankas104613773_tankas
tazzas1436283_tazzas
twangs10358103twan_gs
uranias72113813uranias
vandas103915993_vandas
wallas95719393_wallas
wands96425483_wan_ds
wanes85040883_wan_es
wangan10311233_wangan
wangans1149503_wangans
wanks126124483_wan_ks
wans76452273_wan__s
wants87932213_wan_ts
winzes184313053_winzes
zanza1378703_zanza_

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.406440125.6
2DLD Change Limit134027916.79619721.5
3Display Results91910.0165687.5
 (SQL Overall)178691917.21824756.3
 
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.