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

268 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
defeater12261166(None) 
defeated132812161defeated
defeaters13289101defeaters
deflater123211601deflater
beefeater1443602beefeater
debater104114692de_bater
decenter112412162decenter
defacer132810362def_acer
defamer132710322def_amer
defeat103817162defeat__
defeats113511232defeat_s
defeature1344342defeature
defecate1438792defecate_
defecated1637492defecated
defecates1538592defecates
defecator1546382defecator
defected15289972defected
defector14277952defector
defender1337292defender
deferrer12135592deferrer
deflate113613942deflate_
deflated133412302deflated
deflaters13298702deflaters
deflates123013942deflates
deflator12328342deflator
defoamer14276212defoamer
defrayer1534932defrayer
defter104215922def__ter
deserter91211602deserter
detecter11298732detecter
detester9239682detester
dewater112912422de_water
feater95224052__feater
reheater113413032reheater
repeater102615442repeater
affecter1644523affecter
anteater8311603anteater
beater84729393__beater
beefeaters1553233beefeaters
begetter11136313begetter
beheader1436043beheader
bereaver1346673bereaver
besetter10137983besetter
bleater94515303_bleater
cementer1239193cementer
cheater124816963_cheater
dafter104813343daf__ter
dater65332313d___ater
deader84220473d__eader
deaerate9314173deaerate_
deaerated11311113deaerated
deaerates10313643deaerates
deaerator10128113deaerator
deafer104114813d__eafer
dealate83617843dealate_
dealated103213603dealated
dealates92716683dealates
dealer74122143d__ealer
dearer74822803d__earer
debaser103510413de_baser
debate94419193de_bate_
debated113916083de_bated
debaters113511923de_baters
debates103718533de_bates
debeaked1634613debeaked
decanter112510793decanter
decayer13339353de_cayer
decease1049523decease_
deceased1247713deceased
deceases11410153deceases
deceiver1436233deceiver
decenters122410373decenters
decentre11248553decentre
declarer1148063declarer
deedier93011593de_edier
deemster1175713deemster
deeper93613503de_e_per
deepwater1543713deepwater
deface123113863def_ace_
defaced142910973def_aced
defacers14237993def_acers
defaces133213403def_aces
defame123212433def_ame_
defamed14309833def_amed
defamers14258523def_amers
defames132812253def_ames
defat95426693def_at__
defats105114553def_at_s
defatted1335673defatted
defaulter1343133defaulter
defeating142311973defeating
defeatism1544413defeatism
defeatist1356603defeatist
defeatures1444013defeatures
defecators1656253defecators
defect124816173defect__
defectors15237883defectors
defects134511523defect_s
defence1339893defence_
defenced1537203defenced
defences1439633defences
defended1437223defended
defenders1436363defenders
defense1137503defense_
defensed1336223defensed
defenses1237913defenses
defer94619753def___er
deferred13106363deferred
deferrers13115153deferrers
deffer134411303def__fer
defier105118653def__ier
defiler113911883def_iler
definer114413773def_iner
deflators13348153deflators
defleaed1344953deflea_ed
deflected1635983deflected
deflector1555063deflector
deflower15126073deflower
defoamed15356243defoamed
defoamers15285253defoamers
defogger1443533defogger
deforcer14246903deforcer
deformer14247943deformer
defragger1542603defragger
defrauder1442533defrauder
defrayed1635403defrayed
defrayers1644173defrayers
defroster1343893defroster
defuser115110503def_user
degender1136893degender
degrader11247913degrader
degreaser1144333degreaser
dejected19307593dejected
dejeuner1682933dejeuner
delate73827753de_late_
delated93722873de_lated
delates83526283de_lates
delator83015033de_lator
delayer113010533de_layer
deleaded1148333deleaded
deleave1147723deleave_
deleaved1346573deleaved
deleaves1248063deleaves
delegate10410463delegate_
delegated1238373delegated
delegatee1148803delegatee
delegates1139843delegates
delegator1146243delegator
delete73620703dele_te_
deleted93314913dele_ted
deletes83117933dele_tes
deluster936903deluster
demeaned1237283demeaned
demeanor1143833demeanor
demented12311273demented
demerger12127373demerger
demister11310223demister
dempster1355773dempster
dentate8315153dentate_
dentated10411703dentated
depicter1356853depicter
depleter11298863depleter
deporter1169393deporter
depraver1435413depraver
derate74531233de_rate_
derated93623503de_rated
derates84028893de_rates
desalter938363desalter
descanter1246443descanter
desecrater1346983desecrater
deserted101012203deserted
deserters10129983deserters
deserver12118383deserver
desolater1038383desolater
detected12289733detected
detecters12217753detecters
detector11278323detector
detente83313603detente_
detentes92712873detentes
deter65028043d__e_ter
deterger10147593deterger
deterrer9137013deterrer
detested10279623detested
detesters10298303detesters
devested13239133devested
deviate11312713deviate_
deviated13311043deviated
deviates12312733deviates
deviator1248313deviator
devouter1235513devouter
dewaters122910723de_waters
dexter143810893d__exter
diester83013683d_iester
dieter73516773d_ie_ter
digester10258433digester
dilater83515653d_ilater
dimeter10411893dime_ter
directer1137583directer
diverter12238623diverter
dopester1137253dopester
dreamer104110843d_reamer
eater54639843___eater
effacer15255413_effacer
effecter1664773effecter
elater64724203_e_later
enfetter1145353enfetter
erecter93113393_erecter
eyewater1444243_eyewater
fearer94820183__fearer
feaster10812983__feaster
feather133613503__feather
fester94723513__fester
fetter94120383__fetter
figeater1236953figeater
frater94520593__frater
greater84416493_greater
heater94828303__heater
hefter124313923hef__ter
hereafter1543733hereafter
infecter13229153infecter
infester11239433infester
inflater1149893inflater
keester11319913ke_ester
lefter93613433lef__ter
meeter83616503me_e_ter
neater64424313__neater
negater83711963ne_gater
overeater12312483overeater
perfecter1646043perfecter
pleater93916333_pleater
preheater1448913preheater
rebater93517913re_bater
recenter102715443recenter
redefeated1544883redefeated
reenter73217793re_enter
refected142311663refected
referrer11136053referrer
refilter1137153refilter
reflate103516263reflate_
reflated123514293reflated
reflates113115663reflates
refuter104312193ref_uter
reheated122415003reheated
reheaters122010273reheaters
rejecter17258943rejecter
relater73723143re_later
releaser839503releaser
reletter81311023reletter
repealer103210703repealer
repeated113117443repeated
repeaters112811993repeaters
repenter102813863repenter
reseated93220263reseated
resetter81511833resetter
retreater9310203retreater
revealer113110073revealer
reverter114812873reverter
seater64534163__seater
seawater1136603seawater
sedater83713633se_dater
seedeater1045973seedeater
semester1038903semester
sweater103712723_sweater
teeter65420313te_e_ter
theater104014253_theater
treater74219833_treater
undefeated1546203undefeated
unfetter1136753unfetter

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.423422437.4
2DLD Change Limit1461622687.01620832.7
3Display Results2682680.0932881.7
 (SQL Overall)1786912687.53223724.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.