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

280 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
esteem83881(None) 
esteems935241esteems
beseem1069082bes_eem
esteemed1144472esteemed
ester54727712est_er
esters64627732esters
estrum81810512estrum
mestee84523882mestee_
mestees94617752mestees
seem65438562_s_eem
steam76322932_steam
steed66024942_steed
steek95418002_steek
steel55721992_steel
steep76020702_steep
steer55423862_steer
stem610628252_st_em
teem66132602__teem
testee64323302testee_
testees74215912testees
vestee94319152vestee_
vestees103513172vestees
adeem8311803_adeem
anteed75616113anteed
anthem113410343anthem
asleep847283asleep
aster55434893ast_er
astern64815813astern
asters65631603asters
berseem1166463berseem
beseems1175913bes_eems
bestead10389113bestead
bested94922753best_ed
bestrew1248003bestrew
deem75432893__deem
disesteem1244623disesteem
easter65027983east_er
eastern74412533eastern
easters75125683easters
eaten55323053eat_en
eater54639843eat_er
eaters65535953eaters
eatery95316353eatery
either94517423either
emblem1237583emblem
emcee9315943emcee_
emceed1136283emceed
emcees1037813emcees
emeer74815363e_meer
enter54726383ent_er
entera64216833entera
entered82718883entered
enterer72015633enterer
enters64425643enters
entree61817883entree
entrees71813773entrees
epee64628503e_pee_
epees75219833e_pees
eschew1436333eschew
eses45336103es__es
esker94412983es_ker
eskers105312223eskers
esne47018793es_ne_
esnes54817363es_nes
espied9359773espied
espies83716803espies
esses56422973es_ses
estate64719763estate
estated83715573estated
estates74520183estates
esteeming1244703esteeming
estheses1137783estheses
esthete1047433esthete
esthetes1147743esthetes
estop74312103est_op
estops84011223estops
estral64716513estral
estray95713333estray
estreat7314813estreat
estrin6315923estrin
estrums9208603estrums
estrus61912113estrus
ether84518773e_ther
etwee84115333e_twee
etwees9348793etwees
eustele738193eustele
eusteles838043eusteles
exceed1636173exceed
extend14267523extend
extent132714913extent
extern1348473extern
extrema1675013extrema
extreme1645653extreme
fester94723513fest_er
festered122512103festered
festers104121393festers
genteel836753genteel
geste65920693gest_e_
gestes75721393gest_es
hakeem15407383hakeem
hareem114312063hareem
istle52214713istle_
istles62814983istles
item65620383_it_em
jested144416503jest_ed
jester134319153jest_er
jesters144118193jesters
kestrel1137113kestrel
lateen64014863lateen
lessee64116363lessee_
lessees73510243lessees
listee64223063listee_
listees73416673listees
luteum837783luteum
mentee84121293mentee_
mentees93214503mentees
meseems1165603mes_eems
mesteso937133mesteso
misdeem12217873misdeem
misesteem1344133misesteem
misterm114314513misterm
mustee83922103mustee_
mustees94614923mustees
neem67328083__neem
nested74720063nest_ed
nester64124183nest_er
nesters74422793nesters
nestle63013953nestle_
nestled8349903nestled
nestler73510443nestler
nestles73015463nestles
oestrum9177783oestrum
osteal6312963osteal
osteoma945433osteoma
ostium8310133ostium
ostler63312193ostler
pester84827593pest_er
pestered112814963pestered
pesterer102412703pesterer
pesters93827093pesters
pestier94317403pestier
pestle83215843pestle_
pestled102711443pestled
pestles93217693pestles
posteen93512623posteen
poteen83514263poteen
redeem9311533redeem
resee54336333res_ee_
reseed74823293res_eed
reseek103813133res_eek
reseen64318413res_een
resees63827483res_ees
rested74430783rest_ed
rester63832433rest_er
resters74130403resters
reteam83214533reteam
retem74221953ret_em
sateen63815013sateen
satem76021463_satem
seam66645973_s_eam
see35772263_s_ee_
seed55549483_s_eed
seek85935483_s_eek
seel45042983_s_eel
seems75525023_s_eems
seen46943123_s_een
seep66540343_s_eep
seer45547043_s_eer
sees45361053_s_ees
seme65836653_s_eme
sememe10129983sememe
sestet6826203sest_et
sestets7911473sestets
setae56026223setae_
settee63721023settee
settees73513633settees
setter64023723setter
sheen85023313_sheen
sheep105321523_sheep
sheer84726893_sheer
sheet84836963_sheet
skee85431473_skee_
skeed105018983_skeed
skeen94817403_skeen
skees95023123_skees
skeet95429183_skeet
skelm114211293_skelm
sleek94619043_sleek
sleep74920183_sleep
sleet55639133_sleet
smeek114912353_smeek
sneer54919953_sneer
speed85526623_speed
speel74420763_speel
speer74623903_speer
sperm93216023_sperm
stead65520273_stead
steak95219803_steak
steal56125473_steal
steams84916903_steams
steamy115112373_steamy
steeds73814883_steeds
steeks103613703_steeks
steels64117983_steels
steely93612573_steely
steeps85215193_steeps
steers63820983_steers
steeve93710903_steeve
stein54620543_stein
stela54019043_stela
stele55026843_stele
steles63725663_steles
stemma10328133_stemma
stemmy13417033_stemmy
stems75219953_stems
steno54716863_steno
stent55634513_stent
step67126293_st_ep
steps76619883_steps
stere55328543_stere
stereo65317913_stereo
steres63929533_steres
stern55319123_stern
stet45947323_st_et
stets55423913_stets
stew77525463_st_ew
stewed104814243_stewed
stews85519143_stews
stewy116112063_stewy
stey76224413_st_ey
stied65723033_stied
sties55132983_sties
stime76521803_stime
storm76520403_storm
stream84717293_stream
streek104111413_streek
streel64214023_streel
street64125773_street
strep77120853_strep
strew89220663_strew
strum75619453_strum
stum65526023_st_um
stye76218973_stye_
styed95815483_styed
styes86316523_styes
sweep104715723_sweep
sweer84918573_sweer
sweet85330523_sweet
system1135743syst_em
team66238653__team
tee38366873__tee_
teed55439263__teed
teel46335803__teel
teems76019783__teems
teen45938203__teen
tees45353583__tees
term66233153__term
testae64216253testae_
tested74421523test_ed
tester64227153test_er
testers74124543testers
testes65125823test_es
testier74015643testier
them97427043__them
totem74819373tot_em
tutee5423523tutee_
tutees6514553tutees
unsteel738793unsteel
vested104217353vest_ed
wester94222893west_er
westered122511863westered
western102911093western
westers105221963westers
yester93417983yest_er
yestern10338633yestern
yestreen1144593yestreen
zested164214043zest_ed
zester153617793zest_er
zesters163517293zesters
zestier163010223zestier

Search took 7 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 Filter1786911127160.376475242.0
2DLD Change Limit1127162805.53020382.6
3Display Results2802800.0803500.0
 (SQL Overall)1786912805.98629851.5
 
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.