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 “dadaist” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

165 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
dadaist931010(None) 
dadaism1136441dadaism
dadaists1045581dadaists
dadaisms1245122dadaisms
dadaistic1344792dadaistic
dadas75819862dada_s_
faddist12289642faddist
sadist74221352sad_ist
adapt81218553_ada_pt
adapts9107813_adapts
addict10711203_addict
addrest958623addrest
adit56443653_ad_i_t
adits66523713_ad_its
adjust1447173_adjust
admit8319493_admi_t
admits9411413_admits
admixt1637333_admixt
adrift10313113_adrift
adust64117453_ad_ust
advise10139223_advise
against838383_against
ageist7315383_ageist
agist66325583_a_gist
alist56136783_a_list
aorist64827873_aorist
artist64125543_artist
assist6314593_assist
atavist10311093_atavist
aurist65027253_aurist
autist64324943_autist
avast85519363_ava_st
await85524493_awai_t
awaits96411953_awaits
badass949293bada_ss
baddest112611143baddest
baptist11311873baptist
bassist9312733bassist
cabalist12314493cabalist
caddis104613373caddis_
caddish143810123caddish
cadis84428493cad_is_
cambist13312103cambist
casuist9411303casuist
cladist10311963clad_ist
dacoit9415443dacoi_t
dacoits1079073dacoits
dada66422443dada___
daddies103414943daddies
dadoes85616533dadoes_
dadoing1038523dadoing
dados75522433dad_os_
dads67442773dad__s_
daffiest1537833daffiest
daftest11248943daftest
dais57040703__dais_
daisy95915313__daisy
dakoit11310333dakoi_t
dakoits1245293dakoits
dalasi7610623dala_si
dalasis8810533dalasis
damans94715983damans_
damars93814993damars_
damask1335843dama_sk
dammit11311133dammi_t
dampest12411043dampest
dampish1567663dampish
dandiest103415033dandiest
dandyish1644723dandyish
dandyism1543943dandyism
danish101513793da_nish
dankest122611673dankest
darkest122512623darkest
darkish1537943darkish
dashiest12311113dashiest
dashis104414393dashis_
daubiest1138233daubiest
davit93424593da_vi_t
davits104012363da_vits
daylit10512493dayli_t
deadest93014883dead_est
deadliest1138183deadliest
deadlift1345633deadlift
dedans85915073dedans_
deist64633593__deist
delist74625053d_elist
demast9517063dema_st
dentist8316743dentist
depaint10314593depaint
desist74818813d_esist
dialist8517763dialist
diallist949553diallist
diarist8517113diarist
dicast9315573dica_st
didact10711203dida_ct
didacts1186063didacts
didst74619613did__st
digamist1248203digamist
dodgiest11308713dodgiest
dodoism1135893dodoism
dramatist1258403dramatist
dualist8614053dualist
dudish1148313dud_ish
duelist8511413duelist
dynamist1445343dynamist
dynast1088223dyna_st
faddiest1338113faddiest
faddish15359003faddish
faddism14356723faddism
faddists13235543faddists
fascist1239213fascist
fatalist11314973fatalist
fauvist1336663fauvist
fideist1139753fideist
gaddis94211373gaddis_
gadis74825293gad_is_
haddest122711993haddest
hadjis17439633hadjis_
hadst93220223had__st
hagadist1347603hagadist
halakist15158223halakist
handlist12311333handlist
harpist12312353harpist
jadish17319903jad_ish
judoist1545633judoist
kabalist14410083kabalist
kaddish16317973kaddish
kadis105921063kad_is_
laddish12299723laddish
ladyish14287823ladyish
lanais6316793lanais_
madams11310943madams_
maddest112311213maddest
maddish14289483maddish
maist75535673__maist
malaise9312673malaise
medalist11414203medalist
midlist10312513midlist
nadas66320813nada_s_
narcist9512433narcist
nudist73813323nud_ist
odist6421913_od_ist
padis86227143pad_is_
paganist11411813paganist
palais8420423palais_
palmist112814343palmist
papist102618743pa_pist
qadis155917853qad_is_
racist82822793ra_cist
radars71314663radars_
radiant82817133radiant
radish103516913rad_ish
rapist82520673ra_pist
sacrist9315423sacrist
saddest92412383saddest
sadis64930853sad_is_
sadism94113493sad_ism
sadists83310853sad_ists
satanist8313363satanist
sodalist9311883sodalist
tachist12613293tachist
tanist6324593ta_nist
tubaist938703tubaist
wadis95223963wad_is_
waist86132383__waist

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.1401276364.3
2DLD Change Limit1340271657.59617644.4
3Display Results1651650.0602750.0
 (SQL Overall)1786911657.79622920.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.