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

59 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
zaikais204291(None) 
zaikai1943711zaikai_
aiolis6316843_aiolis
alkalis11148793_alkalis
assais6711963_assais
azukis1963733azuk_is
babkas146010143babka_s
baizas173810823baiza_s
banzais1837163banzais
caimans113811783caimans
daikers124010313daikers
daikons12186693daikons
haika125313793haika__
haiks125120933haik__s
haikus13538293haik_us
ikats95311153__ikats
jackals2036893jackals
jackass2034963jackass
kabikis1243863kabik_is
kaiaks937043kai_aks
kakas85117343ka_ka_s
kakis86116843ka_k_is
lanais6316793la_nais
laogais845813laogais
makars124612633ma_kars
markas124717003marka_s
naiads739013nai_ads
nairas6312783naira_s
paiks114719853paik__s
paisans93614753paisans
paisas84317493paisa_s
palais8420423pa_lais
palikars1445083palikars
parkas125018023parka_s
pikas114218093_pika_s
pikis115116393_pik_is
raias54631123rai_a_s
raitas64417673raita_s
rakis95323443ra_k_is
saigas74114293saiga_s
sakis95323673sa_k_is
shikaris1544923shikaris
shikars1436183shikars
sikas94617023_sika_s
taigas73712563taiga_s
taipans9269553taipans
takas95520683ta_ka_s
tankas104613763tanka_s
tikis95615973_tik_is
uakaris1146633ua_karis
wakikis1342623wakikis
zaffars22325233zaffars
zaibatsu194843zaibatsu
zaires1539703zai_res
zamias174212923zamia_s
zanzas1487053zanza_s
zaribas1836043zariba_s
zirams17438643z_irams
zitis145815583z_i_tis

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.390458182.1
2DLD Change Limit134027596.08022043.9
3Display Results59590.0134538.5
 (SQL Overall)178691596.48327563.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.