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

182 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
deserters1012998(None) 
deserter91211601deserter_
deservers13107291deservers
asserters956392asserters
besetters11136642besetters
decenters122410372decenters
defeaters13289102defeaters
deferrers13115152deferrers
demergers13146402demergers
deporters1277792deporters
desalters1037672desalters
descriers1245692descriers
desecraters1444812desecraters
deserted101012202deserte_d
deserts82513052desert__s
deserver12118382deserver_
deserves12109892deserve_s
desirers939262desir_ers
destriers1038142destriers
detecters12217752detecters
detergers11147182detergers
deterrers10116592deterrers
detesters10298302detesters
diverters13227872diverters
inserters92210282inserters
reservers12138102reservers
resetters9129462resetters
resorters939692resorters
reverters122710432reverters
absenters1156173absenters
assenters966993assenters
asserter877573asserter_
assertors965973assertors
assorters965733assorters
averters11249513_averters
begetters12135043begetters
berserkers1642953berserkers
besetter10137983besetter_
cementers1338313cementers
darters84017603d__arters
deaerates10313643deaerate_s
deaerators11107713deaerators
debarkers16164553debarkers
debaters113511923de_baters
decanters12229223decanters
deceivers1535723deceivers
decenter112412163decenter_
decentres12238523decentres
decreers11277623de_creers
decriers11299733de_criers
deemsters1285023deemsters
defeater122611663defeater_
defectors15237883defectors
defenders1436363defenders
deferrer12135593deferrer_
deflaters13298703deflaters
deforcers15265503deforcers
deformers15266533deformers
degenders1236083degenders
dehorners1344743dehorners
dejeuners1742443dejeuners
deletes83117933dele_te_s
delusters1035983delusters
demerger12127373demerger_
demerges12129503demerge_s
demisters1249203demisters
dempsters1435273dempsters
demurrers1243713demurrers
departees1265723departees
depicters1435823depicters
depleters12327543depleters
deportees1256643deportees
deporter1169393deporter_
desalter938363desalter_
descanters1345013descanters
descenders1445453descenders
describers1543583describers
descrier1157623descrier_
descries11311923descrie_s
desecrater1346983desecrater_
desecrates1348843desecrate_s
desecrators1445233desecrators
desert72725493desert___
desertic1147743desert_ic
desertify1643643desertify
deserting11713143deserting
desertion10410203desertion
desertions1139883desertions
deserve11108703deserve__
deserved13108133deserve_d
desexes1537833dese_xe_s
designers1136003designers
desilvers13306083desilvers
desirer8310783desir_er_
desires81316133desir_e_s
desolaters1146043desolaters
despisers1245153despisers
despites11410313despite_s
desserts9247923dessert__s
destrier9311823destrier_
destroyers1443643destroyers
detecter11298733detecter_
detectors12278303detectors
detentes92712873detente_s
deterger10147593deterger_
deterges101510093deterge_s
deterrer9137013deterrer_
deters74724683d__e_ters
detester9239683detester_
dewaters122910723de_waters
dewormers15255193dewormers
diesters92513603d_iesters
dieters83216433d_ie_ters
digesters11257883digesters
dimeters11411093dime_ters
disarmers1246943disarmers
disasters1039153disasters
discerners1345703discerners
disinters1039713disinters
disorders1146963disorders
dispersers13137423dispersers
disputers1236613disputers
dissenters1197723dissenters
distorters1147163distorters
diverter12238623diverter_
dopesters1237283dopesters
dusters84918363dus__ters
dysentery1643043dysentery
erecters102611613_erecters
esters64627733_es__ters
evertors1138953_evertors
ferreters1246253ferreters
festers104121393fes__ters
inserter82312133inserter_
insetters9187133insetters
inverters12239753inverters
jeerers14328923je_er_ers
jesters144118193jes__ters
keesters12319593ke_esters
meeters94714543me_e_ters
mesentera1144653mesentera
mesentery1444843mesentery
misenters1139533misenters
nesters74422793nes__ters
observers1443973observers
perverters1544963perverters
pesterers112510463pester_ers
pesters93827093pes__ters
presenters1239863presenters
preservers15115693preservers
reenters82915303re_enters
referrers12125373referrers
reheaters122010273reheaters
rejecters18257543rejecters
reletters9138783reletters
repeaters112811993repeaters
repenters112511553repenters
reporters1139173reporters
resellers9299933resellers
reserver11119633reserver_
reserves111011983reserve_s
resetter81511833resetter_
resisters9310453resisters
resorter8312183resorter_
respecters1445863respecters
resters74130403res__ters
retorters938773retorters
reverers113113153rever_ers
reversers12298483reversers
reverter114812873reverter_
seaters74028943__seaters
semesters1139123semesters
sergers83815633__sergers
servers103214833__servers
setters73822063__setters
sorters74221133__sorters
teeters74018303te_e_ters
testers74124543tes__ters
upsetters1143653upsetters
westerners1344473westerners
westers105221963wes__ters
zesters163517293zes__ters

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411827.29620372.9
3Display Results1821820.0762394.7
 (SQL Overall)1786911827.79522923.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.