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

365 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
entrees7181377(None) 
entree61817881entree_
entries71523161entries
antres65021002antr_es
centres93817122centr_es
entases72816272entases
entered82718882entered
enterer72015632enterer
enterers82214152enterers
enters64425642ent_ers
entices91616332entices
entires71517782entires
entraps9109762entraps
entreat7315262entreat
entreats839782entreats
entremets1147142entremets
enures63919712enur_es
enureses838112enureses
etwees9348792e_twees
extremes1756052extremes
gentries91315272gentries
mentees93214502ment_ees
sentries81318062sentries
trees55835762__trees
unfrees1048642unfrees
actress948533actress
agentries1048243agentries
agrees74915323_agrees
ancress978613ancress
anteed75616113ant_eed
antes56334323ant__es
anthems12309423anthems
anthers103715203anthers
antheses11311473antheses
antlers74014743antlers
antre55224523antr_e_
antrums969173antrums
anureses837973anureses
bendees103913863ben_dees
bestrews1335603bestrews
brees75632553__brees
centares102913893centares
centered112513523centered
centers94420603cent_ers
centeses1079443centeses
centiles103615813centiles
centimes124012613centimes
centners1057243centners
centones10313663centones
centrals102712033centrals
centre84316643centr_e_
centred103411683centr_ed
centrums1236913centrums
centuries11311333centuries
decrees102513123decrees
degrees92810723degrees
dentines93418403dentines
dentures9312453dentures
drees65628523__drees
eagres74014573eagr_es
eateries8324323eateries
eaters65535953eat_ers
ecartes94212563ecartes
ectases92911673ectases
ectypes1434803ectypes
editress944933editress
egress73310433e_gress
egrets72712243e_grets
eldress835003eldress
embrues1136473embrues
emcees1037813e_mcees
emerges101310883emerges
emeries91620023emeries
empress1138163empress
enables92813123enables
enamels9128163enamels
enates64026433en_ates
encages103313783encages
encases93116053encases
encodes10310643encodes
encores9315213encores
enders74324053en_ders
endites83717063endites
endives113710693endives
endless839833endless
endorsees1045503endorsees
endorses959973endorses
endrins8312163endrins
endues73813903en_dues
endurers9317953endurers
endures83314603endures
enemies9313693enemies
energies9310783energies
enfaces122110913enfaces
enforces13208013enforces
enframes1357453enframes
engages92912493engages
engines81114463engines
engorges1045753engorges
engrams1038073engrams
engraves1237233engraves
engross837123engross
enisles72312603enisles
enlaces92313393enlaces
enlarges946083enlarges
enrages83114853enrages
enrobes92211113enrobes
enrols61213383en_rols
enserfs1035483enserfs
ensiles72714833ensiles
enskies1138573enskies
ensues63313813en_sues
ensurers8279373ensurers
ensures73315903ensures
entails7912823entails
entasis73012573entasis
ententes8312773ententes
enter54726383ent__er
entera64216833ent_era
enteral73516453enteral
enteric9314213enteric
enterics10312863enterics
enteron7313343enteron
enterons8314153enterons
enthrals11278903enthrals
enthrones12910073enthrones
enthuse1046963enthuse
enthuses1138253enthuses
entice81316863entice_
enticed101411193enticed
enticer91510423enticer
enticers10139093enticers
entire61617703entire_
entirely1147333entirely
entireness1048363entireness
entireties1047273entireties
entirety1146063entirety
entities8617413entities
entitles8710663entitles
entoils7810733entoils
entombs1135613entombs
entrails8310163entrails
entrain7313073entrain
entrains8312963entrains
entrances11310953entrances
entrant7318873entrant
entrants8311753entrants
entrap8710563entr_ap
entreated10310973entreated
entreaties1048113entreaties
entreaty1146173entreaty
entrecotes1244333entrecotes
entrench13115723entrench
entrenches1545213entrenches
entrepot1046193entrepot
entrepots1144253entrepots
entresol844363entresol
entresols944023entresols
entropies11411033entropies
entropy1247353entropy
entrust7410883entrust
entrusts847113entrusts
entry82414263entr__y
entwines1148753entwines
enure53520223enur_e_
enured73315333enur_ed
enuresis845493enuresis
enviers1036993enviers
envies9314053en_vies
enwheel1343403enwheel
enwheels1442853enwheels
enwraps1284833enwraps
enzymes2164413enzymes
epees75219833e__pees
epopees1137233epopees
ernes55224813e__rnes
erses55826803e__rses
estates74520183estates
esteem838813est_eem
esteems935243esteems
esters64627733est_ers
estheses1137783estheses
esthetes1147743esthetes
estrays10529403estrays
estreat7314813estreat
estreats839433estreats
estrins7315853estrins
estrones8313333estrones
estrous7712533estrous
estrums9208603estrums
estrus61912113estr_us
estruses838483estruses
etapes85415293e_tapes
etches114217763e_tches
ethenes103313873e_thenes
ethers94518413e_thers
etudes73811603e_tudes
etwee84115333e_twee_
excretes1787573excretes
express1637493express
externes1539833externes
externs1438233externs
extras13310223extr_as
extrema1675013extrema
extreme1645653extreme
extremer1744653extremer
extremest1855203extremest
extrudes1645243extrudes
eyres84921773e_yr_es
eyries93816813e_yries
frees86131393__frees
gantries91413803gantries
genres75515623gen_r_es
genteel836753gent_eel
gentes75324163gent__es
gentiles93713523gentiles
gentles83714343gent_les
gentrices1258923gentrices
grees65132473__grees
gumtrees1143883gumtrees
hatreds11307813hatreds
henries102718283hen_ries
hirees95117293_hirees
honorees1148783honorees
huntress1144833huntress
inbreds10245733inbreds
inbreed10267643inbreed
inbreeds11234623inbreeds
ingress838653ingress
inheres10315173inheres
intakes11310943intakes
interest8319183interest
internees93014843internees
internes82721233internes
interns73116773interns
inters64328053int_ers
intines7921113intines
intones7816543intones
intreat7416303intreat
intreats8311553intreats
introns73515023introns
intros64215773intr_os
intrudes937493intrudes
inures63318953inur_es
kentes105118653kent__es
kestrels1235813kestrels
knees95114873kn__ees
larees65323113_larees
litres65220393litr_es
matres84522233matr_es
mentee84121293ment_ee_
menthenes1447703menthenes
mestees94617753mest_ees
metres85121563metr_es
mitres83922073mitr_es
nares55544153_nar_es
nereis6315343_nereis
nerves94216193_nerves
netless739863netless
netters73618583netters
nettles73214083nettles
nitres65519333nitr_es
nurses63919353_nurses
outsees72616433outsees
pantries101817393pantries
peltries10313023peltries
pensees9311203pen_sees
pentanes10316083pentanes
pentenes10315633pentenes
pentodes11310363pentodes
pentoses10312893pentoses
penuries10311663penuries
petrels9279373petrels
peytrels1363373peytrels
prees75937173__prees
pugrees10218523pugrees
purees84721683_purees
puttees93612913puttees
reentries9311773reentries
rees45364193___rees
referees111310413referees
renters74224823rent_ers
rentes65431193rent__es
rentiers83311763rentiers
restress82511773restress
retirees84611653retirees
retries74129073retries
sarees65329943_sarees
screes85023973_screes
senores73218113senor_es
settees73513633settees
sirees64624583_sirees
sirrees73410573sirrees
snarers74216663snarers
snares65329033snar_es
snorers74313803snorers
snores64324323snor_es
soirees72411643soirees
sprees85620643_sprees
steres63929533_steres
streek104111413_streek
streeks11378713_streeks
streel64214023_streel
streels73811343_streels
street64125773_street
streets73312623_streets
streps86218063_streps
stress66616673_stress
strews96817103_strews
suttees74114063suttees
tees45353583__t_ees
tenrecs936033ten_recs
tentages91011043tentages
tentered96412103tentered
tenters73921113tent_ers
tentless8229843tentless
tenures7412013tenur_es
testees74215913test_ees
threes97117323_threes
titres64718933titr_es
tree47745813__tree_
treed65626733__treed
treen55622753__treen
treens65317873__treens
treks96016853__treks
tres46542903__tr_es
tress55423163__tress
trets55928023__trets
trews86118893__trews
treys85018213__treys
tries55742813__tries
trues54925323__trues
tutees6514553tut_ees
tyees86019453__tyees
undress838893undress
unfree9413203unfree_
unfreed11510123unfreed
unreel63612933un_reel
unreels7258313un_reels
unstress837373unstress
unties64326923unt_ies
untread857413untread
untreads936223untreads
untried82615853untried
untrims938613untrims
untrue6310773untrue_
untruer737113untruer
untruest847783untruest
untruss736553untruss
untunes72211253untunes
vendees114011453ven_dees
veneries112815033veneries
venires103012453venir_es
ventages12119773ventages
venters103717733vent_ers
ventless11249053ventless
ventrals112910003ventrals
venturers1245523venturers
ventures11311493ventures
vestees103513173vest_ees
vestries11314053vestries
votress1035483votress
yentes95517603yent__es
yestreen1144603yestreen
yestreens1243533yestreens

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 Filter1786911340270.390458182.1
2DLD Change Limit1340273656.03322215.6
3Display Results3653650.1562339.7
 (SQL Overall)1786913656.57927160.8
 
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.