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

165 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
eupnea83503(None) 
eupneas935231eupneas
eupnoea943161eupnoea
apnea73413412_apnea
eupneic1144482eupneic
eupnoeas1042802eupnoeas
guinea737612guinea
usnea539392_usnea
apneal83411123_apneal
apneas83211383_apneas
apnoea867093_apnoea
buna64730723bu_n_a
bunya103810093bu_nya
bupkes144811483bupkes
burned95818963burned
burner83819203burner
burnet84326173burnet
cornea84018923cornea
cuneal8611513cu_neal
cunner83915003cunner
cupel9514303cup_el
cupola10317693cupola
cuppa11398523cup_pa
cupped134413983cupped
cupper124313863cupper
cupula10328433cupula
dipnet91317473dipnet
duenna734593duenna
dune56137583du_ne_
dunes65332173du_nes
dunned85015523dunned
dunner73913823dunner
dupe76630603dup_e_
duped95118323dup_ed
duper85519003dup_er
dupes86425933dup_es
duple85315863duple_
duplex16386973duplex
dupped124411643dupped
durned84113173durned
dyspnea1352813dyspnea
earned74818333earned
earner63617223earner
elodea738673elodea
empanel1145963empanel
empyema1642643empyema
enema7612743e__nema
ennead736253e_nnead
epee64628503e_p_ee
epees75219833e_pees
epha9310053e_p_ha
equine151711573equine_
equines161811593equines
erne46727433e_rne_
ernes55224813e_rnes
erupted10207163erupted
esne47018793e_sne_
esnes54817363e_snes
espied9359773espied
espies83716803espies
etna46415263e_tn_a
eugenia847713eugenia
euglena843953euglena
eupnoeic1243493eupnoeic
eureka1034483eureka
evened101010313evened
evener91010623evener
exine125518493exine_
exines135715803exines
expel1448233exp_el
expend16247503expend
eyne76322463e_yne_
funned103613953funned
funnel93610743funnel
funner93414103funner
guineas836753guineas
gunned83513093gunned
gunnel73411053gunnel
gunnen7338713gunnen
gunner73813983gunner
gurnet74920873gurnet
gurney10429413gurney
hyponea1546453hyponea
jeepney1942093jeepney
junta123713673ju_nta
jupe134921003jup_e_
jupes145218553jup_es
kuna85120703ku_n_a
kune85424573ku_ne_
luna46229853lu_n_a
lune47140493lu_ne_
lunes55337773lu_nes
lunet56835423lu_net
lupine84013533lupine_
lupines93912503lupines
lutea54819073lu_tea
ouphe104413263ouphe_
ouphes113614633ouphes
pea56657243__p_ea
perinea9313033perinea
plea66830603__plea
puna65331653pu_n_a
punka114515483pu_nka
punned93416193punned
punner84918153punner
punnet83518843punnet
pupa85422813pup__a
pupae96515643pupae_
pupped105013273pupped
puppet93514593puppet
quanta153911333quanta
quelea1547303quelea
quinela1635213quinela
quinoa15377653quinoa
quinta153312373quinta
ruana5312423ruan_a
ruined74813323ruined
ruiner64013643ruiner
rune45236303ru_ne_
runes55530223ru_nes
runnel63510663runnel
runner63814463runner
rupee7321283rup_ee
rupees8312573rupees
subnet82520933subnet
subpena1136673subpena
subsea82610193subsea
sunna55016063su_nna
sunned74216323sunned
supe65932763sup_e_
super74924483sup_er
supes75628303sup_es
supine84216693supine_
supines94216383supines
supped114415703supped
supper104115433supper
supra73614253sup_ra
tinea54923163_tinea
tuna45127843tu_n_a
tune45635863tu_ne_
tuned64622313tu_ned
tuner56022683tu_ner
tunes55332193tu_nes
tunned74014493tunned
tunnel64310633tunnel
tupped114013233tupped
turned73914473turned
turner63914613turner
ulna46317333_uln_a
ulnae55214573_ulnae
unpeg8309363_unpeg
unpen72913573_unpen
upbear1096493_upbear
upbeat10911513_upbeat
upend85011043_upend
upheap13105213_upheap
upleap10106843_upleap
upped103715163_upped
upper93714263_upper
uprear8168793_uprear
upset73222593_upset
uptear896783_uptear
urea46528063_u_rea
usneas638333_usneas
uvea74712653_u_vea

Search took 6 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 Limit1127161654.89023050.3
3Display Results1651650.0463587.0
 (SQL Overall)1786911655.31233639.1
 
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.