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

85 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
zaikai194371(None) 
zaikais2042911zaikais
haika125313792haika_
aioli5318313_aioli
alkali10127563_alkali
askoi9507803_askoi
assai5711543_assai
azuki1864803azuk_i
babka137812913babka_
babkas146010143babkas
baiza164813223baiza_
baizas173810823baizas
banzai1737653banzai
caiman103615663caiman
daiker115113033daiker
daikon11217243daikon
gardai839663gardai
haik115526983haik__
haiks125120933haik_s
haiku126113693haik_u
haikus13538293haikus
ikat87626643__ikat
jackal1937613jackal
kabiki1134783kabik_i
kaiak8310353kai_ak
kaiaks937043kaiaks
kaka76518683ka_ka_
kakas85117343ka_kas
kaki76520913ka_k_i
laical8312323laical
lanai5319573la_nai
laogai735983laogai
litai55216363_litai
makar115614973ma_kar
marka114620793marka_
markas124717003markas
moirai886913moirai
naiad6313403nai_ad
naira5314743naira_
nairas6312783nairas
paik105726803paik__
paiked135113433paiked
paiks114719853paik_s
paisa76021073paisa_
paisan84417073paisan
paisas84317493paisas
palikar1335453palikar
parka115120883parka_
parkas125018023parkas
pika106322953_pika_
pikas114218093_pikas
piki106520563_pik_i
raia46638383rai_a_
raias54631123rai_as
raita54623073raita_
raitas64417673raitas
raki87127833ra_k_i
saiga64717933saiga_
saigas74114293saigas
saki85628483sa_k_i
shikar1336803shikar
shikari1444513shikari
sika86021323_sika_
sikas94617023_sikas
taiga64115673taiga_
taigas73712573taigas
taipan82410663taipan
taka87623593ta_ka_
takas95520683ta_kas
tanka93817493tanka_
tankas104613773tankas
tiki87620843_tik_i
uakari1046863ua_kari
wakiki1233463wakiki
zaffar21385043zaffar
zaire14311993zai_re
zaires1539703zaires
zamia165115213zamia_
zamias174212923zamias
zanza1378703zanza_
zanzas1487053zanzas
zariba1736983zariba_
zaribas1836043zaribas
ziram163912893z_iram
ziti136022373z_i_ti

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.406440125.6
2DLD Change Limit112716855.73319660.9
3Display Results85850.0302833.3
 (SQL Overall)178691856.16928966.0
 
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.