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 “deters” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

198 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
deters7472468(None) 
daters74827371daters
deers64930521de_ers
defers105116941defers
deter65028041deter_
dieters83216431dieters
doters74423911doters
meters85625831meters
peters86624591peters
aethers103614942aethers
afters94717072afters
alters64924222alters
asters65631602asters
beaters94925042beaters
beers75628392be_ers
belters93819412belters
betels84515062betels
betters94422092betters
biters83925242biters
caters85336502caters
ceders93817672ceders
centers94420602centers
cetes75731102cete_s
citers85022982citers
darers75921872darers
darters84017602darters
dater65332312dater_
dates65639152date_s
deairs74013782deairs
dealers84118612dealers
dears65736882de_ars
debars94218042debars
debaters113511922debaters
debtors1038532debtors
decern91310952decern
decerns10119052decerns
deckers144413832deckers
decors94017772decors
deeds75423762de_eds
deems85421772de_ems
deeps84921772de_eps
deer56739022de_er_
dees56356632de_e_s
deets65330242de_ets
defer94619752defer_
defiers113913992defiers
defter104215922defter_
degerm1037892degerm
degerms1135622degerms
deicers103612732deicers
dekes105224452deke_s
deles65139252dele_s
delvers113411992delvers
demes86032692deme_s
demurs939772demurs
denars74621432denars
denes65639722dene_s
deniers84515182deniers
deperm1139362deperm
deperms1236602deperms
desert72725492desert
deserts82513052deserts
detect94217402detect
detects104011092detects
detent73624482detent
detents83615152detents
deterge9118462deterge
deterges101510092deterges
detest74122842detest
detests83711742detests
detours858042detours
devels104313902devels
dewars105117072dewars
dewaters122910722dewaters
dexes135224512dexe_s
dexter143810892dexter_
dicers94720742dicers
diesters92513602diesters
dieter73516772dieter_
diethers1257452diethers
dikers114418792dikers
dimers94321092dimers
dimeters11411092dimeters
diners75525952diners
dites66339152dite_s
dithers114016152dithers
divers105024962divers
doers65225712d_oers
dopers95522482dopers
dosers75723632dosers
doter65428622doter_
dotes65836692dote_s
dotters83715972dotters
dowers104523292dowers
dozers164815422dozers
driers74516732driers
dryers10449272dryers
duelers83412052duelers
dupers94615602dupers
dusters84918362dusters
dyers96617132d_yers
eaters65535952eaters
edgers84413922edgers
egers65120372_egers
enters64425642enters
esters64627732esters
ethers94518412_ethers
ewers86018822_ewers
eyers86521332_eyers
festers104121392festers
fetes85630142fete_s
fetors91014472fetors
fetters103517902fetters
fevers125414892fevers
gaters74728642gaters
getters84216102getters
haters94930402haters
heaters104225222heaters
heders104119762heders
hefters134312002hefters
hetero9312632hetero
heteros10312682heteros
hewers123715272hewers
hexers165612752hexers
inters64328052inters
jeers124818132je_ers
jesters144118192jesters
jetes124922842jete_s
kelters113813752kelters
kiters105218592kiters
leers54828982le_ers
legers74518312legers
lepers84817322lepers
letters73819852letters
levers94621322levers
liters65429882liters
maters85032392maters
meeters94714542meeters
melters93918312melters
meteors94610012meteors
meter75130322meter_
metes74736212mete_s
metiers93312842metiers
metres85121562metres
miters84328782miters
nesters74422792nesters
netters73618582netters
neuters74212272neuters
niters64624212niters
noters64021002noters
oaters65029792oaters
otters64021512otters
outers64230172outers
oxters134813272oxters
paters84935832paters
peers75130272pe_ers
pelters93720312pelters
pesters93827092pesters
peter74427592peter_
petters93722362petters
pewters124113352pewters
raters63936582raters
refers93921082refers
renters74224812renters
resters74130402resters
retears72814922retears
retems83914572retems
revers94529632revers
seaters74028942seaters
seders74420282seders
seers55136382se_ers
setters73822062setters
severs94121122severs
sewers94719722sewers
steers63820982steers
taters64932202taters
teeters74018302teeters
tenters73921102tenters
testers74124542testers
tethers103815312tethers
tetters74320472tetters
titers64526412titers
toters65026362toters
ureters7311822ureters
utters63817122utters
veers84521362ve_ers
venters103717732venters
vetoers10359472vetoers
vetters104016322vetters
vexers165210402vexers
voters95017442voters
waters95030632waters
webers11310942webers
welters103516062welters
westers105221962westers
wethers135214692wethers
wetters103817752wetters
zesters163517292zesters

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit825511982.39034540.2
3Display Results1981980.0802475.0
 (SQL Overall)1786911982.81363523.3
 
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.