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

152 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
didacts118606(None) 
didact10711201didact_
deducts1166592deducts
dicasts1078702dicasts
didactic1445182didactic
didactics1543492didactics
didactyl1542182didactyl
directs102710262directs
misacts1139352misacts
redacts10510942redacts
abducts1265313abducts
acts66929863___acts
adapts9107813_adapts
addicts1176013addicts
adducts1174603adducts
bidets95215533bid_ets
bifaces1448063bifaces
bipacks1745043bipacks
bisects1137133bisects
bracts105617773_bracts
coacts105314333_coacts
daces85030683__daces
dadaist9310103dadaist
dadaists1045583dadaists
dadas75819863dada__s
darts67635733__darts
dauts67822243__dauts
dawts97216123__dawts
decants103514443decants
decocts1237833decocts
dedans85915073deda_ns
deduces1168793deduces
deduct10610793deduct_
defaces133213403defaces
defats105114553defa_ts
defects134511523defects
dejects17389223dejects
delicts104012253delicts
demasts1089223demasts
departs104310683departs
depicts12358463depicts
derats74625063dera_ts
desalts839573desalts
detects104011093detects
detracts11138833detracts
diacid10310633di_acid
diacids1137863di_acids
diadems1135393diadems
dialects11126003dialects
dials64925343di_a_ls
dicast9315573dicast_
dices86434243di__ces
dicks125824693di__cks
dicots94915793di_cots
dicta84915633di__cta
dicty115116293di__cty
diddles103915073diddles
didies84621833did_ies
didoes85716963did_oes
didos76820813did__os
didst74619613did_st_
diebacks1745963diebacks
diets66026643di__ets
diffracts1843223diffracts
digests93610613digests
dights114016963di_ghts
digits84114533di_gits
diglots9299503diglots
diktats1235623diktats
dilate73220693dila_te
dilates83220663dilates
dimouts1037893dimouts
dimwits1344513dimwits
dinars75417563dina_rs
dints67431313di__nts
dipnets10109033dipnets
diquats1745983diquats
dirams94413703dira_ms
direct93817333direct_
dirts66824463di__rts
disarms1039043disarms
discants112912023discants
discos94915213di_scos
discs85316263di_sc_s
discus94512113di_scus
disdains1037913disdains
disjects18275923disjects
dismasts1137513dismasts
disparts11109953disparts
dissects11279243dissects
distracts1249283distracts
ditas65923673dita__s
dits56450523di___ts
divans104612393diva_ns
divas95418583diva__s
diverts114412033diverts
divests114510933divests
divots104712203di_vots
diwans105110373diwa_ns
dixits144210313di_xits
doats65224883d_oa_ts
dopants1038433dopants
drafts105012533d_rafts
drats66628373d_ra_ts
ducats95011763duca_ts
ducts85319893__ducts
dynasts1155103dynasts
edicts94911703_edicts
educts9439893_educts
enacts84012973_enacts
epacts105010393_epacts
exacts15359613_exacts
facts107021893__facts
fiats85324483fi_a_ts
fidgets12388763fidgets
giants74713503gi_ants
hijacks2333533hijacks
idiots768643_idiots
ikats95311153_ika_ts
impacts13266503impacts
indicts103210723indicts
inducts10259573inducts
lidars7310783lida_rs
lilacs837483lilac_s
linacs8310813linac_s
midairs1037203midairs
midgets113910253midgets
midguts11296013midguts
midsts95510053mid_sts
misact10316693misact_
mudcats1236223mudcats
nidate7313783nida_te
nidates8311893nidates
nidgets9358143nidgets
outacts9310213outacts
oviducts1442073oviducts
oxidants1643933oxidants
pacts95125803__pacts
pedants10310113pedants
preacts113211363preacts
reacts83616603_reacts
redact9419043redact_
tacts76524123__tacts
tidbits1035183tidbits
tincts84510803ti_ncts
tipcats1137103tipcats
tracts85019073_tracts
updarts1034203updarts
viaducts1442293viaducts
vivaces1536413vivaces
widgets12318453widgets
wildcats1444173wildcats

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.546327272.9
2DLD Change Limit1340271525.89022755.0
3Display Results1521520.0632412.7
 (SQL Overall)1786911526.49927495.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.