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

236 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
desalter93836(None) 
desalted1038311desalted
desalters1037671desalters
dealer74122142de_al_er
debater104114692deba_ter
decaliter1247982decaliter
decanter112510792decanter
defaulter1343132defaulter
deflater123211602deflater
dekaliter1445062dekaliter
desalt7518312desalt__
desalts839572desalt_s
descanter1246442descanter
deserter91211602deserter
desilver12286502desilver
desolater1038382desolater
dewater112912422dewa_ter
disaster949942disaster
drysalter1341932drysalter
exalter1437562_exalter
misalter1038342misalter
psalter9247812_psalter
realter73716312re_alter
salter64325082__salter
alter54828503___alter
assaulter942753assaulter
basaltes10367683basaltes
beater84729393be_a_ter
belter84720963be__lter
besetter10137983besetter
bespatter1343143bespatter
betatter1035453betatter
dafter104813343d__after
darter75320363d__arter
dater65332313d__a_ter
deader84220473de_a_der
deadlier1036863deadlier
deafer104114813de_a_fer
dealate83617843de_alate_
dealated103213603de_alated
dealates92716683de_alates
dealers84118613de_al_ers
dealt65234283de_alt__
dearer74822803de_a_rer
debarker15155503debarker
debaser103510413deba_ser
debate94419193deba_te_
debated113916083deba_ted
debaters113511923deba_ters
debates103718533deba_tes
decaliters1345213decaliters
decameter14137363decameter
decanted122310493decanted
decanters12229223decanters
decayer13339353deca_yer
decenter112412163decenter
deciliter1247033deciliter
declarer1148063declarer
deemster1175713deemster
defacer132810363defa_cer
defamer132710323defa_mer
defatted1335673defatted
defaulted1443313defaulted
defaulters1442383defaulters
defeater122611663defeater
defiler113911883defil_er
deflate113613943deflate_
deflated133412303deflated
deflaters13298703deflaters
deflates123013943deflates
deflator12328343deflator
defter104215923de__fter
degasser10325813degasser
dekaliters1543413dekaliters
dekalitre1442823dekalitre
dekameter16135103dekameter
delate73827753dela_te_
delated93722873dela_ted
delates83526283dela_tes
delator83015023dela_tor
delayer113010533dela_yer
deluster936903deluster
delver104913493de__lver
demander12238723demander
demasted1238763demasted
demister11310223demister
dempster1355773dempster
departed1238823departed
departee1139723departee
depicter1356853depicter
depleter11298863depleter
deporter1169393deporter
deranger1037353deranger
derate74531233dera_te_
derated93623503dera_ted
derates84028893dera_tes
deratted1048403deratted
desalting1138843desalting
desanded11227453desanded
descanted1336673descanted
descanters1345013descanters
descrier1157623descrier
deserted101012203deserted
deserters10129983deserters
deserver12118383deserver
designer1036543designer
desilvers13306083desilvers
desirer8310783des_irer
desisted1039783desisted
desolate9411993desolate_
desolated1139653desolated
desolaters1146043desolaters
desolates10311793desolates
desolator1046673desolator
despairer1243693despairer
despiser1136343despiser
despite10410123despite_
despited1248323despited
despites11410313despites
destrier9311823destrier
desulfur1242433desulfur
desultory1343403desultory
detacher1437543detacher
detailer9268673detailer
detainer92910793detainer
detecter11298733detecter
deter65028043de___ter
detester9239683detester
devalue1136013devalue_
devalued1335013devalued
devalues1235853devalues
devouter1235513devouter
dewaters122910723dewa_ters
dexter143810893de__xter
dialer74315433d_ial_er
dialler848813d_ialler
diaster82813313d_iaster
diester83013683dies__ter
dilater83515653dila_ter
disabler1147913disabler
disarmer1138033disarmer
disasters1039153disasters
disinter9310673disinter
dismaler1137903dismal_er
disputer1137973disputer
drafter11449433d_rafter
drysalters1441853drysalters
drysaltery1751263drysaltery
duster74919723dus__ter
easter65027983_e_aster
eater54639843_e_a_ter
elater64724203_ela_ter
espalier1036363_espalier
ester54727713_es__ter
exacter1637403_exacter
exalted1537393_exalted
exalters1536653_exalters
falter94519053__falter
feaster10812983fe_aster
feater95224053fe_a_ter
fester94723513fes__ter
gasalier936443gasalier
gestalten1042713gestalten
halter94420883__halter
healer94221803he_al_er
heater94828303he_a_ter
insulter836883insulter
jester134319153jes__ter
kelter103214383ke__lter
levanter1145303levanter
mealier93015903me_alier
measlier1036013measlier
melter83520113me__lter
misalters1136913misalters
neater64424313ne_a_ter
negater83711963nega_ter
nester64124183nes__ter
nestler73510453nestl_er
palter84423263__palter
pearter9412743pe_arter
pedaler103410693pedal_er
pedalfer1443273pedalfer
pedalier1137603pedalier
pedaller1136093pedaller
pelter83321623pe__lter
pester84827593pes__ter
prealter1048863prealter
psalters10227713_psalters
psaltery13224733_psaltery
realer63528593re_al_er
realters83614043re_alters
realtor73611353re_altor
rebater93517913reba_ter
recaller1039323recaller
recanter101913153recanter
refilter1137153refilter
regaler83814623regal_er
relater73723143rela_ter
remaster10311473remaster
resale64025543resal_e_
resales74724903resal_es
resalute857413resalute_
resaluted1046473resaluted
resalutes947433resalutes
reseller83412253reseller
resetter81511833resetter
resilver11337503resilver
resister8311653resister
reslate73520593reslate_
reslated93517523reslated
reslates83619503reslates
resolder9259233resolder
resoluter966183resoluter
resolver11339793resolver
resorter8312183resorter
rester63832433res__ter
resulted939713resulted
revolter11279363revolter
salted74121203__salted
saltern74010653__saltern
salters73622253__salters
saltier74318633__saltier
saluter73512453__saluter
salver94617753__salver
sealer63928963se_al_er
seater64534163se_a_ter
sedater83713633seda_ter
slater64429183__slater
tester64227153tes__ter
unsalted9510923unsalted
vealer94016543ve_al_er
vealier102712173ve_alier
welter93417383we__lter
wester94222893wes__ter
yester93417983yes__ter
zester153617793zes__ter

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.420425454.8
2DLD Change Limit1461622367.43619656.0
3Display Results2362360.0962458.3
 (SQL Overall)1786912367.95222471.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.