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

234 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
decanter11251079(None) 
decanted122310491decanted
decanters12229221decanters
decenter112412161decenter
descanter1246441descanter
recanter101913151recanter
canter85230112__canter
debater104114692deba_ter
decaliter1247982decaliter
decameter14137362decameter
decane93818872decan_e_
decanes103118912decan_es
decant93524222decant__
decants103514442decant_s
decayer13339352deca_yer
decenters122410372decenters
decentre11248552decentre
demander12238722demander
deranger1037352deranger
desalter938362desalter
descanted1336672descanted
descanters1345012descanters
dewater112912422dewa_ter
levanter1145302levanter
recanted112513512recanted
recanters112310482recanters
recenter102715442recenter
scanter94215182_scanter
banter84825333__banter
beater84729393be_a_ter
betatter1035453betatter
cancer104220923__cancer
caner75334773__can_er
canker124422523__canker
canner84625983__canner
canoer85121073__canoer
canted94825783__canted
canters94827733__canters
cantor85621523__cantor
carter84932273__carter
caster85232573__caster
cater74840723__ca_ter
cementer1239193cementer
center84421413__center
chanter123919733_chanter
dafter104813343d__after
dancer94817613d__ancer
dander811222993d__ander
danger83722823d__anger
danker114319663d__anker
darter75320363d__arter
dater65332313d__a_ter
daunter83811753d_aunter
deader84220473de_a_der
deafer104114813de_a_fer
dealer74122143de_a_ler
deaned84620453de_an_ed
deanery1137613de_an_ery
dearer74822803de_a_rer
debarker15155503debarker
debaser103510413deba_ser
debate94419193deba_te_
debated113916083deba_ted
debaters113511923deba_ters
debates103718533deba_tes
deboner103110483debon_er
debunker1543093debunker
decade104216163deca_de_
decades113615513deca_des
decaliters1345213decaliters
decameters15156593decameters
decamped1634963decamped
decanal1038113decan_al
decanting132510633decanting
decare93919153deca_re_
decares102818533deca_res
decayed14309333deca_yed
decayers14307963deca_yers
deceiver1436233deceiver
decent94023703decent__
decentered1445323decentered
decentest1249083decentest
decently1448013decently
decentred13236233decentred
decentres12238523decentres
decider114213183dec_ider
deciliter1247033deciliter
decimeter14147413decimeter
decipher1644423decipher
decker135215993dec__ker
declaimer1444233declaimer
declarer1148063declarer
decliner113710843decliner
decocted1437683decocted
decoder113712293dec_oder
decoyer13348683dec_oyer
decreer10269123dec_reer
decrier102713553dec_rier
deemster1175713deemster
defacer132810363defa_cer
defamer132710323defa_mer
defanged1435433defanged
defatted1335673defatted
defaulter1343133defaulter
defeater122611663defeater
defender1337293defender
definer114413773defin_er
deflater123211603deflater
defter104215923de__fter
degasser10325813degasser
degender1136893degender
dekaliter1445063dekaliter
dekameter16135103dekameter
delate73827753dela_te_
delated93722873dela_ted
delates83526283dela_tes
delator83015023dela_tor
delayer113010533dela_yer
deluster936903deluster
demanded13348513demanded
demanders13247573demanders
demasted1238763demasted
demented12311273demented
demister11310223demister
dempster1355773dempster
denier74420693de__nier
denser74115193de__nser
dented84120513de__nted
depainted1375843depainted
departed1238823departed
departee1139723departee
depicter1356853depicter
depleter11298863depleter
deporter1169393deporter
derange939813derange_
deranged1137693deranged
derangers1136703derangers
deranges1039973deranges
derate74531233dera_te_
derated93623503dera_ted
derates84028893dera_tes
deratted1048403deratted
deringer1038143deringer
dernier83011943de_rnier
desalted1038313desalted
desalters1037673desalters
desanded11227453desanded
descant104315583descant__
descants112910143descant_s
descender1346663descender
deserter91211603deserter
detacher1437543detacher
detailer9268673detailer
detainer92910793detainer
detecter11298733detecter
detente83313603detente_
detentes92712873detentes
deter65028043de___ter
detester9239683detester
devouter1235513devouter
dewaters122910723dewa_ters
dexter143810893de__xter
diaster82813313d_iaster
dilater83515653dila_ter
disaster949943disaster
discanted1339333discanted
disinter9310673disinter
drafter11449423d_rafter
easter65027983_e_aster
eater54639843_e_a_ter
ecarte84313503_ecarte_
ecartes94212563_ecartes
elater64724203_ela_ter
enchanter1446193enchanter
enter54726383_e__nter
exacter1637403_exacter
exalter1437563_exalter
feaster10812983fe_aster
feater95224053fe_a_ter
granter84117133_granter
heater94828303he_a_ter
incanted11259543incanted
incenter102212093incenter
indecenter1345023indecenter
leaner64022193le_an_er
levanted1245323levanted
levanters1254993levanters
locater93113603loca_ter
meander1049973me_ander
meaner84617843me_an_er
neater64424313ne_a_ter
negater83711963nega_ter
pearter9412743pe_arter
picante11310523picante_
planter94017803_planter
precancer1547093precancer
ranter63826823__ranter
realter73716313re_alter
rebater93517913reba_ter
recaller1039323recaller
recamier1237603recamier
recane83022873recan_e_
recaned102817203recan_ed
recanes93222263recan_es
recant83228683recant__
recants93217093recant_s
recharter1466893recharter
reciter94117263rec_iter
reconfer1337673reconfer
recounter1137943recounter
reenter73217793re_enter
reinter73116843re_inter
relater73723143rela_ter
remaster10311473remaster
renter64527413re__nter
repenter102813863repenter
scanner94411813_scanner
scanted104114393_scanted
scantier10309983_scantier
scatter93815173_scatter
seater64534163se_a_ter
secant84023293secant__
secantly1345983secantly
secants93413893secant_s
secateur1042923seca_teur
seconder1137183seconder
secreter1038513secreter
sedater83713633seda_ter
tenanted937043tenanted
tenter64623933te__nter
venter94218723ve__nter
wanter94423053__wanter
weaner93816773we_an_er
webcaster1642383webcaster

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 Filter1786911461620.403443402.0
2DLD Change Limit1461622346.66021946.2
3Display Results2342340.0932516.1
 (SQL Overall)1786912347.15624970.8
 
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.