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

156 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
defer9461975(None) 
deafer104114811deafer
deer56739021de_er
defers105116941defers
deffer134411301deffer
defier105118651defier
defter104215921defter
deter65028041deter
refer84822141refer
beer65635992be_er
ceder85322242ceder
dafter104813342dafter
darer65230792darer
dater65332312dater
deader84220472deader
deafen10389672deafen
deair65817192deair
dealer74122142dealer
dear55343602de_ar
dearer74822802dearer
debar85517862debar
decern91310952decern
decker135215992decker
decor84717572decor
dee47665822de_e_
deed65340902de_ed
deem75432892de_em
deep76031882de_ep
deeper93613502deeper
deers64930522de_ers
dees56356632de_es
deet57356582de_et
def76546722def__
defacer132810362defacer
defamer132710322defamer
defat95426692defat
defeat103817162defeat
defect124816172defect
defend113910492defend
defi86321492def_i
defied115016382defied
defiers113913992defiers
defies104624052defies
defiler113911882defiler
definer114413772definer
defis96717502defis
deflea1037442deflea
defog1048522defog
deform1259622deform
deft85540222def_t
defuel10348932defuel
defuser115110502defuser
defy114921262def_y
degerm1037892degerm
deicer94114412deicer
deifier113013122deifier
deke95228762deke_
deked115718532deked
dekes105224452dekes
dele56843082dele_
deled75326542deled
deles65139252deles
delver104913492delver
deme76536282deme_
demes86032692demes
demur8311162demur
denar65223292denar
dene56643412dene_
denes65639722denes
denier74420692denier
denser74115192denser
deperm1139362deperm
dere56845902dere_
desert72725492desert
desex13311982desex
deters74724682deters
devel94217122devel
dewar95817732dewar
dewed105020302dewed
dewier104013462dewier
dexes135224512dexes
dexter143810892dexter
dicer85426422dicer
dieter73516772dieter
differ133910842differ
diker105524552diker
dimer85625602dimer
diner65632902diner
direr64927072direr
diver94827802diver
doer57734702d_oer
doffer133911352doffer
doper86128392doper
doser66228562doser
doter65428622doter
dower95027702dower
dozer158419272dozer
drier64423962drier
dryer95111462dryer
dueler74213682dueler
duffer134711662duffer
duper85519002duper
dyer85522112d_yer
edger75215952edger
eger55923572_eger
ever77027692_ever
ewer77523982_ewer
eyer76127282_eyer
fer66646122__fer
fever115617952fever
fewer115216122fewer
feyer115014522feyer
fifer115519972fifer
gofer94814282gofer
heder95623642heder
hefter124313922hefter
heifer1238202heifer
hewer115719932hewer
hexer155116682hexer
infer84215032infer
jeer115426462je_er
jefe146516882jefe_
jefes155613672jefes
kefir12457912kefir
leer46239352le_er
lefter93613432lefter
leger65721512leger
leper74820742leper
lever85125162lever
liefer9529572liefer
lifer85822152lifer
merer75126232merer
meter75130322meter
never86218642never
newer85717462newer
offer114311382offer
peer66238352pe_er
peter74427592peter
prefer113813202prefer
reefer93314362reefer
refed93921922refed
refel84920812refel
refers93921082refers
rifer84721982rifer
safer84721812safer
seder64826762seder
seer45547042se_er
serer55935512serer
sever85426052sever
sewer84426222sewer
telfer9379892telfer
veer76229572ve_er
vexer155513522vexer
wafer114417642wafer
weber10313522weber
weer75535092we_er

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 Filter178691538000.310576422.6
2DLD Change Limit538001561.87628678.0
3Display Results1561560.0463391.3
 (SQL Overall)1786911562.23280058.7
 
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.