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

131 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
enneads83473(None) 
ennead736251ennead_
anneals7449952anneals
endears83710052endears
enneadic1142772enneadic
kneads11357092_kneads
unleads8228622unleads
anears63717183_anears
annals66415923ann_als
annas55824883ann_a_s
anneal64812303annea_l
annelids946233annelids
annexes1437203annexes
annuals7388193annuals
apneas83211383apnea_s
beads85429503__beads
beheads1338523beheads
bennes86019013benne__s
bennets94712163benne_ts
besteads11307123besteads
breads95419203_breads
coheads13289233coheads
coleads102911423coleads
deads75726913__deads
deleads9379703deleads
denned84215633denne_d_
dreads84115023_dreads
egads74610923e__gads
eggheads1442923eggheads
embeds11377903embe_ds
emends95711433e_mends
endear74110013endea_r
ended74421263ende_d_
enders74324053ende_rs
endleafs1242723endleafs
ends56528533e_n__ds
endways1444443endways
enemas8812003e_nemas
enfolds11136253enfolds
engilds974863engilds
engirds995053engirds
engrams1038073engrams
enneagon942173enneagon
enneagons1042133enneagons
ennuis636473enn_uis
enserfs1035483enserfs
enters64425643ente_rs
entraps9109763entraps
entreats839773entreats
enwinds11255553enwinds
enwraps1284833enwraps
ernes55224813erne__s
esnes54817363esne__s
etnas54713933etn_a_s
eupneas935233eupnea_s
exceeds1733843exceeds
expends17217083expends
extends15227113extends
fennecs12305693fenne_cs
fennels10387903fenne_ls
gonads84511733gon_ads
heads95127113__heads
hennaed1135103hennaed_
hennas94211803henn_a_s
innards837153innards
inned64118423inne_d_
inners63919353inne_rs
inroads837043inroads
inseams9307903inseams
intends8239963intends
jennets14517633jenne_ts
jetbeads1842483jetbeads
kenned114411273kenne_d_
kennels11387193kenne_ls
knead10429663_knead_
kneepads15102263kneepads
leads66028493__leads
maenads1037373maenads
meads85425323__meads
menads95514383men_ads
monads94515303mon_ads
naiads739013_naiads
neaps75618323__neaps
nears55529423__nears
neats55931903__neats
needs65719633__needs
nenes55329673nene__s
nerds65719253__nerds
nereids838743nereids
nicads938333_nicads
nomads94711603_nomads
onloads8246673onloads
oreads73915773_oreads
penned94217613penne_d_
penners93414183penne_rs
pentads1039523pentads
pineals93212853pineals
pinheads14336243pinheads
pleads94613953_pleads
reads64835273__reads
redheads1336173redheads
rennets75212633renne_ts
repleads11357213repleads
rereads81512293rereads
retreads937823retreads
sennas64214233senn_a_s
sennets73712583senne_ts
sneaks104312493_sneaks
sneaps84510863_sneaps
sneds65715353_sne_ds
spreads1039763spreads
steads74116223_steads
tenners74014923tenne_rs
threads11419953threads
tineas64616483tinea_s
tineids8337873tineids
tonneaus853913tonneaus
treads74817923_treads
unbears998043unbears
unbends10236993unbends
undead82711903undead_
unlead73312373unlead_
unloads8278523unloads
unread73412673unread_
unready11215943unready
unseals73212583unseals
unseams9338913unseams
unseats73012853unseats
untreads936223untreads
usneas638333usnea_s
yenned10409383yenne_d_

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.530337152.8
2DLD Change Limit1340271317.05019010.9
3Display Results1311310.0462847.8
 (SQL Overall)1786911317.62623431.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.