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 “deni” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

198 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
deni5692939(None) 
defi86321491defi
deli55631291deli
den47554341den_
dene56643411dene
denim85518841denim
dens55945071dens
dent57158411dent
deny86027121deny
ani37751182_ani
bani65334962bani
ben56554922ben_
bend76435262bend
bene66439492bene
benni74715362benni
bens65945702bens
bent67759912bent
cedi74919272cedi
cent67451012cent
coni65534802coni
dan46859672dan_
dang65131542dang
danio6319782danio
dank95828242dank
dans56748152dans
de37049542de__
dead65434242dead
deaf85838402deaf
deair65817192deair
deal56347412deal
dean56039482dean
deans66131392deans
dear55343602dear
deb66342692de_b
debit85727852debit
debs76530242debs
debt77139022debt
deck115827752deck
deco76125972deco
dee47665822de_e
deed65340902deed
deem75432892deem
deep76031882deep
deer56739022deer
dees56356632dees
deet57356582deet
def76546722de_f
defis96717502defis
deft85540222deft
defy114921262defy
deil56231622deil
deke95228762deke
del46752752de_l
dele56843082dele
delf85436572delf
delis64928542delis
dell56938202dell
dels56745472dels
delt57855272delt
deme76536282deme
demic105119192demic
demit84832302demit
demo77427552demo
demy105422852demy
denar65223292denar
denari710917352denari
denes65639722denes
denial74720512denial
denied84318632denied
denier74420692denier
denies74729642denies
denims95214322denims
dense65923502dense
dentil74017882dentil
dentin73919572dentin
dents65031802dents
dere56845902dere
derm76031892derm
desk95618902desk
dev76033772de_v
deva85720982deva
devil94714732devil
devs86424032devs
dew77139922de_w
dews86230602dews
dewy115419022dewy
dex116936882de_x
dexie134716892dexie
dexy156118552dexy
dey77243372de_y
deys85027472deys
diene65720132diene
din46459462din_
dine55555332dine
ding66940952ding
dink97137802dink
dino56036752dino
dins56652042dins
dint56759052dint
djin12911632djin
don46757652don_
dona55529632dona
done55747912done
dong66031652dong
dons56048702dons
duci76422622duci
dui46433382d_ui
dun46545582dun_
dune56137582dune
dung66328432dung
dunk96228572dunk
duns55140432duns
dunt55746872dunt
dyne85320932dyne
edenic9310222edenic
en28052392_en_
end46834352_end
eng46726782_eng
ens37245922_ens
fen66851352fen_
fend84832972fend
fens76139762fens
gen45950512gen_
gene56237222gene
genic85119392genic
genie66124922genie
genii64514172genii
genip84415202genip
gens55740072gens
gent56954392gent
genu55929072genu
hen67555272hen_
hens75642572hens
hent76656382hent
ken76343982ken_
keno87926432keno
kens85435232kens
kent86846962kent
kepi105315632kepi
lei36846382le_i
lend56233672lend
lenis56326862lenis
leno47331392leno
lens46146492lens
lent46360532lent
men59252852men_
mend75334032mend
meno66031362meno
menu65130232menu
mini65634562mini
muni65824412muni
nene45932062nene
nevi75116422nevi
pein65834942pein
pen56558842pen_
pend75934532pend
penis75129322penis
penni74617902penni
pens65649642pens
pent66559072pent
peri65636972peri
rani46640112rani
rei35647252re_i
rein46040892rein
rend56136572rend
renig64518912renig
renin54830032renin
rent46661242rent
segni63712482segni
sei36048932se_i
semi65127222semi
sen36058522sen_
send55237292send
sene46848052sene
sengi64016512sengi
sent46963012sent
senti56226702senti
ten35856112ten_
tend56433772tend
tenia55324482tenia
tens45647412tens
tent46159862tent
vein75625752vein
vena76126292vena
vend86626422vend
venin85118662venin
vent76049052vent
wen66249602wen_
wend85330452wend
wens76337932wens
went76051872went
xenia124814772xenia
xenic144114642xenic
yen66847382yen_
yens75832262yens
yeti75823212yeti
yoni77524392yoni
zein135620602zein

Search took 2 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 Filter178691298720.266671770.7
2DLD Change Limit298721980.76339150.7
3Display Results1981980.0464304.3
 (SQL Overall)1786911981.075166224.2
 
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.