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

202 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
esteems93524(None) 
esteem838811esteem_
beseems1175912bes_eems
esteemed1144482esteemed
esters64627732est_ers
estrums9208602estrums
meseems1165602mes_eems
mestees94617752mestee_s
seems75525022_s_eems
steams84916902_steams
steeds73814882_steeds
steeks103613702_steeks
steels64117982_steels
steeps85215192_steeps
steers63820982_steers
stems75219952_st_ems
teems76019782__teems
testees74215912testee_s
vestees103513172vestee_s
adeems946333_adeems
anthems12309423anthems
asters65631603ast_ers
berseems1263933berseems
beseem1069083bes_eem_
besteads11307123besteads
bestrews1335603bestrews
deems85421773__deems
disesteems1342883disesteems
easters75125683east_ers
eaters65535953eat_ers
emblems1335043emblems
emcees1037813emcee_s
emeers83314183e_meers
enterers82214153enterers
enters64425643ent_ers
entrees71813773entrees
epees75219833e_pee_s
eschews1534553eschews
eses45336103es__e_s
eskers105312223es_kers
esnes54817363es_ne_s
espies83716803espie_s
esses56422973es_se_s
estates74520183estates
esteeming1244703esteeming
ester54727713est_e_r
esterase849483esterase
estheses1137783estheses
esthesis1148463esthesis
esthete1047433esthete
esthetes1147743esthetes
estops84011223est_ops
estovers1136453estovers
estrays10529403estrays
estreat7314813estreat
estreats839433estreats
estrins7315853estrins
estrous7712533estrous
estrum81810513estrum_
estrus61912113est_rus
ethers94518413e_thers
etwees9348793e_twees
eusteles838043eusteles
exceeds1733843exceeds
extends15227113extends
extents142610173extents
externs1438233externs
extrema1675013extrema
extreme1645653extreme
extremes1756053extremes
festers104121393fest_ers
gestes75721393gest_e_s
hakeems16394803hakeems
hareems12428203hareems
istles62814983istle_s
items7499613_it_ems
jesters144118193jest_ers
kestrels1235813kestrels
lateens74210553lateens
lessees73510243lessee_s
listees73416673listee_s
mentees93214503mentee_s
mestee84523883mestee__
mestesos1045223mestesos
misdeems13255653misdeems
misesteems1442493misesteems
misterms123711353misterms
mustees94614923mustee_s
neems77316293__neems
nesters74422793nest_ers
nestlers8359233nestlers
nestles73015463nestle_s
oestrums10156473oestrums
osteoma945433osteoma
osteomas1045333osteomas
ostlers72911203ostlers
pesterers112510463pesterers
pesters93827093pest_ers
pestles93217693pestle_s
posteens10309733posteens
poteens92910883poteens
redeems1037163redeems
reseeds84012333res_eeds
reseeks11348623res_eeks
resees63827483res_ee_s
resters74130403rest_ers
restless82713163restless
restress82511773restress
reteams9339563reteams
retems83914573ret_ems
sateens73710753sateens
seams75731663_s_eams
seeds64330063_s_eeds
seeks94724643_s_eeks
seels55632823_s_eels
seem65438563_s_eem_
seeps74828753_s_eeps
seers55136383_s_eers
sees45361053_s_ee_s
sememes11109203sememes
semes75731583_s_emes
sestets7911473sest_ets
settees73513633settees
setters73822063setters
sheens95116993_sheens
sheers94322403_sheers
sheets93918503_sheets
skeens103912913_skeens
skees95023123_skee_s
skeets104513253_skeets
skelms12368023_skelms
sleeks104512463_sleeks
sleeps83913323_sleeps
sleets64318873_sleets
smeeks12428433_smeeks
sneers64016173_sneers
speeds94316053_speeds
speels85116393_speels
speers85019953_speers
sperms102512603_sperms
steads74116223_steads
steaks104415853_steaks
steals64020063_steals
steam76322933_steam_
steamy115112373_steamy
steed66024943_stee_d
steek95418003_stee_k
steel55721993_stee_l
steely93612573_steely
steep76020703_stee_p
steer55423863_stee_r
steeve93710903_steeve
steeves103410903_steeves
steins64818343_steins
steles63725663_steles
stem610628253_st_em_
stemma10328133_stemma
stemmas11256973_stemmas
stemmy13417033_stemmy
stenos63915773_stenos
stents65019453_stents
steps76619883_st_eps
stereos74314973_stereos
steres63929533_steres
sterns64616763_sterns
stets55423913_st_ets
stews85519143_st_ews
sties55132983_stie_s
stimes85920573_stimes
storms85814633_storms
streams94713373_streams
streeks11378713_streeks
streels73811343_streels
streets73312623_streets
streps86218063_streps
stress66616673_stress
strews96817103_strews
strums84716453_strums
stums75320083_st_ums
styes86316523_stye_s
sweeps114110513_sweeps
sweets94214433_sweets
systems1234683syst_ems
teams75726513__teams
teels55726373__teels
teem66132603__teem_
teens56227483__teens
tees45353583__tee_s
terms75523473__terms
testee64323303testee__
testers74124543test_ers
testes65125823test_e_s
totems86810763tot_ems
tutees6514553tutee_s
unsteels845793unsteels
vestee94319153vestee__
vestless11258843vestless
westerns11328963westerns
westers105221963west_ers
yestreens1243533yestreens
zesters163517293zest_ers
zestless17247433zestless

Search took 9 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.626285448.9
2DLD Change Limit1340272028.25016245.7
3Display Results2022020.0633206.3
 (SQL Overall)1786912028.93919990.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.