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

448 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
dresser8361195(None) 
dressed93511871dressed
dressers9359861dressers
dresses83716171dresses
dressier956861dressier
presser93717621presser
addresser1143402addresser
blesser9329292blesser
caresser1038802caresser
crasser94114332crasser
creaser94415722creaser
cresses94219812cresses
cresset93319942cresset
crosser95015462crosser
denser74115192d_enser
dessert82916452d_essert
diester83013682diester
dosser74417972d_osser
dreamer104110842dreamer
dredger10347442dredger
dress65319832dress__
dressy10518142dress_y
drosses84513822drosses
drossier956312drossier
duresses939172duresses
fresher132612642fresher
greaser83913082greaser
grosser84313142grosser
guesser8166542guesser
lesser63514852_lesser
pressed103317312pressed
pressers103215022pressers
presses93523152presses
pressor93512872pressor
prester93519622prester
redresser1056792redresser
rester63832432_rester
tressed83714262tressed
tressel73010892tressel
tresses73719542tresses
tressier847962tressier
trusser74010262trusser
wrester102812412wrester
addressed1243653addressed
addressee1143963addressee
addressers1242673addressers
addresses1165633addresses
addressor1142503addressor
amasser9418733amasser
arouser74514423arouser
arrester839253arrester
artsier768943artsier
blessed10319493blessed
blessers10277633blessers
blesses93812393blesses
brasher124515243brasher
brasier94516753brasier
brassed103612373brassed
brasses93818353brasses
brassier103310533brassier
breaker133912923breaker
breeder103210043breeder
brevier1237763brevier
brewer114812543bre_wer
brisker134210293brisker
brisses94314313brisses
browser124911143browser
bruiser9349573bruiser
brusher123813003brusher
brusker13437853brusker
caressed1139163caressed
caressers1137433caressers
caresses10314063caresses
censer84516583_censer
cessed94615613_cessed
cesses84221363_cesses
chesses124112633chesses
classer93614613classer
crasher124616163crasher
creamer113714083creamer
crease85519573crease_
creased104315583creased
creasers103612823creasers
creases94020963creases
creasier103210193creasier
creeper11339973creeper
creese84014333creese_
creeses93914623creeses
crepier1139733crepier
cress75022833cress__
cressets10309103cressets
cressy11439113cress_y
crested103416533crested
crisper113511053crisper
crosier94116573crosier
crosse85216303crosse_
crossed105313893crossed
crossers103912703crossers
crosses94220793crosses
cruiser93410433cruiser
crusher124412323crusher
cusser86016093_cusser
dabster1036703dabster
dasher104318983d_asher
deader84220473d_eader
deafer104114813d_eafer
dealer74122143d_ealer
dearer74822803d_earer
debaser103510413debaser
decker135215993d_ecker
deedier93011593deedier
deemster1175713deemster
deeper93613503d_eeper
deer56739023d_e__er
defer94619753d_e_fer
deffer134411303d_effer
defier105118653d_efier
defter104215923d_efter
defuser115110503defuser
degasser10325813degasser
degreaser1144333degreaser
deicer94114413d_eicer
delver104913493d_elver
denier74420693d_enier
dense65923503d_ense_
deposer104011843deposer
depressed1357623depressed
depresses1259883depresses
depressor1265173depressor
derider93214973derider
deriver114213913deriver
dernier83011943dernier
desert72725493d_e_sert
desex13311983d_e_sex
desire7415303d_esire
desirer8310783d_esirer
despiser1136343d_espiser
desserts9247923d_esserts
deter65028043d_e_ter
detester9239683detester
deviser114212393deviser
dewier104013463d_ewier
dexter143810893d_exter
diaster82813313diaster
diesel74410403die_sel
dieses75218693die_ses
diesters92513603diesters
dieter73516773die_ter
diether1147443diether
digester10258433digester
digressed1245613digressed
digresses1137863digresses
directer1137583directer
dissed85220183d_issed
dissert83720693d_issert
disses75225963d_isses
ditsier83010293ditsier
dopester1137253dopester
dorser74819183d_orser
doser66228563d__oser
dossed84516633d_ossed
dossel74813643d_ossel
dossers84516233d_ossers
dosses76126273d_osses
dossier83711693dossier
douser75621633d_ouser
dowser104716083d_owser
drabber12438593drabber
drafter11449423drafter
dragger10309173dragger
dragster1034623dragster
drainer83012843drainer
draper94315693dr_aper
drawer104711363dr_awer
drawler11338593drawler
dreaded103612023dreaded
dreamed114310633dreamed
dreamers11369003dreamers
dreamier11287293dreamier
drear65016903dre__ar
drearier9297923drearier
dredge9308553dredge_
dredged11346883dredged
dredgers11256093dredgers
dredges10379343dredges
dree56638323dre__e_
dreed75222843dre__ed
drees65628523dre__es
dreggier1193553dreggier
dregs76114863dregs__
dreidel934473dreidel
dreks105714753dreks__
drencher14257213drencher
dressage1044253dressage
dressages1144153dressages
dressiest1036823dressiest
dressily1246443dressily
dressing102810423dressing
dressmaker1751923dressmaker
drest65530343dre_s_t
drier64423963dr__ier
drifter11348703drifter
driller84311883driller
drinker12349483drinker
dripper12349233dripper
driver104714493dr_iver
droller84110283droller
droner74717673dr_oner
dropper12329873dropper
drosera836203dr_osera
dross65418093dross__
drossy10528473dross_y
drover104614593dr_over
drowner11369803drowner
drowse105010553drowse_
drowsed12448743drowsed
drowses114610233drowses
drowsier1284903drowsier
drubber12357863drubber
drudger10328323drudger
drummer12407503drummer
drunker12326633drunker
druse64817663dr_use_
druses75517253dr_uses
dryer95111463dr__yer
drynesses1335363drynesses
dueler74213683due_ler
dueller8329833dueller
duress74712063duress__
duster74919723d_uster
dweller11297273dweller
egressed1046873egressed
egresses949443egresses
eldresses1045673eldresses
eraser64216333er_aser
erecter93113393erecter
esker94412983__esker
esses56422973__esses
ester54727713__ester
expresser1845733expresser
fesse86116333_fesse_
fessed104515063_fessed
fesses94820253_fesses
fester94723513_fester
flenser1036783flenser
flesher133610923flesher
flosser10339693flosser
foreseer1139013foreseer
forester11313673forester
frasses104314513frasses
freer86021243fre__er
freezer19348523freezer
frescoer1345983frescoer
freshed143312593freshed
freshen133010883freshen
freshes133515823freshes
freshet133416643freshet
fresnel1035893fresnel
fretter103412753fretter
frisker14389273frisker
fusser94813773_fusser
gasser75017773_gasser
geyser1036513_geyser
glosser83410813glosser
grasper10389793grasper
grassed93812793grassed
grasses84117343grasses
grassier9349283grassier
grease75416233grease_
greased93812393greased
greasers93410253greasers
greases84816713greases
greasier9298083greasier
greater84416493greater
greener83111713greener
greeter82812673greeter
greisen856503greisen
greyer104510093gre_yer
grister83915413grister
grossed93812253grossed
grossers94410973grossers
grosses84517683grosses
grouser84513693grouser
guessed9176603guessed
guessers9174903guessers
guesses8169373guesses
harasser1137033harasser
hisser94713793_hisser
idlesse834193idlesse_
idlesses936003idlesses
jesse126012833_jesse_
jessed144112303_jessed
jesses135215953_jesses
jester134319153_jester
keester11319913keester
kiester11329973kiester
kisser104212453_kisser
knesset11310413knesset
kreuzer2032353kreuzer
leaser65322673_leaser
lessee64116363_lessee
lessen64212433_lessen
lessor64010603_lessor
loesses7310033loesses
messed95018183_messed
messes84924343_messes
messier93412923_messier
mosser84618273_mosser
nesses64718323_nesses
nester64124183_nester
ogresses938473ogresses
oyesses1037333oyesses
passer84721033_passer
peruser93511373peruser
pester84827593_pester
pisser84416383_pisser
pleaser93912343pleaser
plessor9317693plessor
praiser93413943praiser
preaver121011613preaver
preciser123411663preciser
preener93114833preener
prefer113813203pre_fer
premier113515633premier
presager1138443presager
prese75228383pre_se_
preset84430983pre_set
presider11410423presider
press75425953press__
pressmen1238833pressmen
pressors103212683pressors
pressure1039773pressure
presters103419003presters
presumer1247583presumer
preyer114413733pre_yer
prissed103311263prissed
prisses94816713prisses
prissier10157873prissier
processer1346893processer
proser84223463pr_oser
prosier93817483prosier
prosper114012193prosper
prosses94019513prosses
quester161410023quester
raiser66620103_raiser
raser55633413_r_aser
rasher95024123_rasher
rasper83917333_rasper
raster64731443_raster
reader73628293_reader
realer63528593_realer
reamer84325213_reamer
reaper84223143_reaper
rearer64928913_rearer
reassert8313673_reassert
reaver94524733_reaver
redder83918133_redder
redressed1137773redressed
redressers1145103redressers
redresses10410293redresses
redressor1064223redressor
reefer93314363_reefer
reeker103715593_reeker
reeler63822573_reeler
refer84822143_re_fer
refuser104912783_refuser
reissuer854523_reissuer
reiver95318293_reiver
relier65826183_relier
render74024143_render
renter64527413_renter
reposer93715333_reposer
represser1168953represser
rescuer939033_rescuer
resee54336333_re_see
reseed74823293_reseed
reseek103813133_reseek
reseen64318413_reseen
resees63827483_resees
reset55051863_re_set
resew84519503_re_sew
reshes94124363_reshes
resider84615803_resider
resister8311653_resister
rested74430783_rested
resters74130403_resters
resumer9410113_resumer
reuse56025363_reuse_
reused75419563_reused
reuses66025523_reuses
reviser104114663_reviser
rinser64317213_rinser
riser55431053_r_iser
risker105414493_risker
rooser63921883_rooser
rosier64221263_rosier
roster64329083_roster
rouser65224083_rouser
rusher94019653_rusher
russet6319433_russet
seiser65318343_seiser
stressed9128543stressed
stresses81112493stresses
stressor875533stressor
teaser65421523_teaser
tenser64919433_tenser
terser67317823_terser
tessera736333_tessera
tester64227153_tester
thresher1455823thresher
tosser64215663_tosser
trasher104416133trasher
trasses74819323trasses
treader84113833treader
treater74219833treater
trekker1034733trekker
tress55423163tress__
tressels8367653tressels
tressour844573tressour
tressure846483tressure
tressy9448553tress_y
trouser73812473trouser
trussed84010033trussed
trussers8348283trussers
trusses73813643trusses
truster73114313truster
tryster10369513tryster
tusser64615833_tusser
undressed1138343undressed
undresses1039313undresses
urease64516993urease_
ureases74416723ureases
ureter6313203ure_ter
verser94516963_verser
vesper1138083_vesper
vessel937953_vessel
wester94222893_wester
wrasse9398773wrasse_
wrasses103812593wrasses
wreaker143610043wreaker
wrecker16367603wrecker
wrested113410933wrested
wresters112711733wresters
wrestler11306993wrestler
yessed104511163_yessed
yesses93615813_yesses
yester93417983_yester
zester153617793_zester

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 Filter1786911340270.403443402.0
2DLD Change Limit1340274486.81319672.2
3Display Results4484480.1562871.8
 (SQL Overall)1786914487.37224239.1
 
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.