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

134 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
diktats123562(None) 
diktat11310691diktat_
dictate10311662dictate
dictates11311382dictates
diquats1745982diquats
ditas65923672di_ta_s
ikats95311152_ik_ats
biotas84313923biota_s
bistate9313823bistate
bitts75022593bi_t_ts
dakoits1245293dakoits
defats105114553d_efats
defeats113511233defeats
deltas74414823delta_s
dentals83915393dentals
dentate8315153dentate
derats74625063d_erats
dials64925343di__als
diatoms1039073diatoms
dicast9315573di_cast
dicasts1078703dicasts
dicots94915793di_cots
dicta84915633dicta__
dictated1239203dictated
dictator1147263dictator
dictators1247363dictators
dictums1235553dictums
didacts1186063didacts
dietary1158663dietary
dieters83216433dieters
diets66026643di__ets
digests93610613digests
dights114016963di_ghts
digitals1045433digitals
digitate1098683digitate
digits84114533di_gits
diglots9299503diglots
dikdiks1242563dikdiks
dikers114418793dik_ers
dikes105831333dik__es
dilatants1044513dilatants
dilatate947773dilatate
dilate73220693di_late
dilates83220663dilates
dimouts1037893dimouts
dimwits1344513dimwits
dinars75417563di_nars
dingbats1245013dingbats
dints67431313di__nts
dioxans1555313dioxans
dipnets10109033dipnets
dipsas9359893dipsa_s
diquat1639763diquat_
dirams94413703di_rams
directs102710263directs
dirhams13376313dirhams
dirtbags1242703dirtbags
dirties83119383dirties
dirts66824463di__rts
disbars10310323disbars
discants112912023discants
dismals102010243dismals
dismast10311233dismast
dismasts1137513dismasts
dismays13237433dismays
disparts11109953disparts
disrate81418523disrate
disrates91118153disrates
disseats93211503disseats
distaff1467683distaff
distaffs1565083distaffs
distain8313783distain
distains9413603distains
distal73615773dista_l
distant83519953distant
distaste939943distaste
distastes1039633distastes
distaves12311403distaves
distils83015803distils
distorts91112353distorts
distracts1249283distracts
dita56032523di_ta__
dites66339153di_t_es
dits56450523di___ts
dittany1135653dittany
ditties83116983ditties
ditto65315603di_t_to
dittos74111973di_ttos
ditty95019293di_t_ty
ditzes163212423di_tzes
divans104612393di_vans
divas95418583di_va_s
diverts114412033diverts
divests114510933divests
divots104712203di_vots
diwans105110373di_wans
dixits144210313di_xits
doats65224883d__oats
drats66628373d__rats
ducats95011763d_ucats
fiats85324483fi__ats
ikat87626643_ik_at_
iotas54821113_iota_s
kats85944333__k_ats
khats125316013__khats
kismats13257843kismats
kyats125012443__kyats
litas54923773li_ta_s
mikvahs19162493mikvahs
miseats92815783miseats
mitts75523753mi_t_ts
nictate9310223nictate
nictates1039593nictates
pietas84516503pieta_s
pikas114218093pik_a_s
pintas85021393pinta_s
pitas77427673pi_ta_s
pittas86014523pitta_s
qintars16268573qintars
riatas63915093riata_s
sikas94617023sik_a_s
sitars65417593si_tars
skats94621543_sk_ats
stats55933363__stats
tats46858133___tats
tictacs1145793tictacs
tikkas934523tikka_s
tipcats1137103tipcats
titans63414913ti_tans
vistas94513273vista_s
vitals94514303vi_tals
vittate10409733vittate
witans93412933wi_tans
zikurats2142493zikurats

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.1431249587.4
2DLD Change Limit1340271347.00019146.7
3Display Results1341340.0462913.0
 (SQL Overall)1786911347.18924856.2
 
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.