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

280 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
daphnes1332768(None) 
daphne12237011daphne_
daphnia1345052daphnia
daphnias1444682daphnias
dapples1238992dapples
dapsones1138382dapsones
dashes106124982dash_es
dauphines1544342dauphines
depones103717092depones
diaphones1547442diaphones
raphes115117452raph_es
rapines95120862rapines
achenes12313493_achenes
aches106132293_ach_es
acnes75922623_a_cnes
agenes74720253_agenes
agones75719863_agones
akenes104817343_akenes
alines65735223_alines
alpines94016193alpines
amines84727983_amines
anes45255933_a__nes
apes66047433_ap__es
apexes1539133_apexes
apheses12610703_apheses
aphides134711203_aphides
aphids125110843_aphids
aphis105917133_aph_is
apices104916263_apices
apnea73413413_ap_nea
apneas83211383_ap_neas
apples104315763_apples
apres75426403_ap_res
apses76823913_ap_ses
aptness9268573_aptness
arenes64928393_arenes
ashes86230613_ash_es
atones65225773_atones
axones134614513_axones
azines155517073_azines
baches135426943bach_es
banes74945583ba__nes
bashes115631393bash_es
bathes116524833bath_es
caches137926913cach_es
cajones163311333cajones
camphenes1846463camphenes
camphines1847563camphines
canes75350373ca__nes
canines93724033canines
capes95441923cap__es
caphs124515373caph__s
capizes20410373capizes
capons104119503capon_s
capotes11314643capotes
cashes114729883cash_es
dabbles124514773dabbles
daces85030683da__ces
dachas124113253dach_as
dacites101114593dacites
daddies103414943daddies
daddles104213803daddles
dadoes85616533da_does
daemones11209163daemones
daftness1235533daftness
daggles103611913daggles
dagoes85714603da_goes
dahls95012283da_h_ls
dahs88231813da_h__s
dailies84219263dailies
daimones11208803daimones
dairies84217733dairies
daises74318983da_ises
daisies84217093daisies
dales66439743da__les
dalles74222063da_lles
dallies84023193dallies
damages11511273damages
damans94715983daman_s
dames85435853da__mes
damned104212913da_mned
damner95213433da_mner
damners104112113da_mners
damns84916923da_mn_s
dampened1435623dampened
dampener1335533dampener
dampeners1444663dampeners
dampens12348563dampen_s
dampings14377523dampings
dampness1336073dampness
dances95120653da_nces
dandies94121443dandies
dandles94218533dandles
dangles93618423dangles
dangs75623203da__ngs
dankness13256693dankness
dans56748153da__n_s
dapped124516763dap_ped
dapper114016633dap_per
dapple1138853dapple_
dappled1336393dappled
daps77239163dap___s
dapsone1038463dapsone_
darbies104216983darbies
dares66146703da__res
darings93713653darings
darkens12409873darkens
darkies124015753darkies
darkles124011933darkles
darkness13247343darkness
darned85018483da_rned
darnel74312183da_rnel
darnels83710433da_rnels
darner74017303da_rner
darners83815773da_rners
darns66927893da_rn_s
dartles84014133dartles
dashed115920563dash_ed
dasheen1136393dasheen
dasheens1244693dasheens
dasher104318983dash_er
dashers115016863dashers
dashier114311183dashier
dashiest12311113dashiest
dashis104414393dash_is
dassies84418663dassies
dates65639153da__tes
datives11310073datives
daubes94913703da_ubes
daunts75014083da_unts
dauphine1444493dauphine_
dauphins1444523dauphins
dauties83315763dauties
davened124610073davened
davens104612913daven_s
davies105020513da_vies
dawdles12379163dawdles
dawned113912093da_wned
dawns95916593da_wn_s
dawties113312703dawties
dazes155024143da__zes
dazzles1636413dazzles
deashes113313903deash_es
debones103315113debones
decanes103118913decanes
defines114118683defines
denes65639723d__enes
depends11348993depends
deplanes11311213deplanes
depone93616553depone_
deponed113712873deponed
deposes103117213deposes
deputes104911783deputes
diamines11311643diamines
diaphone1447103diaphone_
diaphonies1645823diaphonies
diaphyses1844123diaphyses
diazines1838713diazines
dienes75719903d_ienes
dines66449153d__ines
diphase1387273diphase
diploes101111493diploes
dipnet91317473dip_net
dipnets10109033dip_nets
dipoles101013753dipoles
dishes104622653dish_es
divines113514723divines
domines102918973domines
dopants1038433dopants
dopes84935043dop__es
dopiness11289973dopiness
dopings11408783dopings
drapes95419653drap__es
drones75023433d_rones
duchies133312313duchies
dunes65332173d__unes
dupes86425933dup__es
dwines105013103d_wines
dynes95917583d__ynes
earphones1448393earphones
famines123216263famines
fanes84639893fa__nes
fashes124524023fash_es
gamines103618463gamines
gapes86030823gap__es
gashes105725153gash_es
hapaxes1936593hapaxes
happens14359173happens
haptenes133810823haptenes
haptens124511343haptens
hashes125024803hash_es
hyphens1836043hyphens
imphees1436693imphees
impones112712253impones
janes124928123ja__nes
japans1539823japan_s
japes146322823jap__es
kanes95529373ka__nes
kaphs144911503kaph__s
laches116528343lach_es
lacunes9159623lacunes
lagunes8148523lagunes
lanes54946793la__nes
lapides103012043lapides
lapins84520683lapin_s
lapises93513463lapises
lapses85217693lap_ses
lashes94831003lash_es
lathes95127493lath_es
lawines103313563lawines
lupines93912503lupines
maches134827233mach_es
machines15312893machines
mahoes11313103ma_hoes
malines93625603malines
manes76648963ma__nes
maples104819423map_les
marines93928013marines
mashes115030003mash_es
mashies12318253mashies
naches114622413nach_es
napes74828463nap__es
nappes104515623nap_pes
nappies114613393nappies
opines84820703_opines
orpines94414793orpines
ouphes113614633ouph_es
panes76148693__panes
pannes85522853pa_nnes
pappies103214823pappies
papules112411573papules
pashes115828393pash_es
patines95225763patines
pavanes123612653pavanes
penes75839223__penes
phones114121213__phones
pines76048863__pines
pones74547043__pones
rapes75740723rap__es
raphae114311733raphae_
raphe104916423raph_e_
raphias123511083raphias
raphides14188393raphides
raphis114014323raph_is
rapine85023083rapine_
rappees113611453rappees
raptness1046733raptness
rashes95330153rash_es
rashness1138093rashness
ratines75328583ratines
ravines104220233ravines
repines94927383repines
rhaphes1534703rhaph_es
sabines94318483sabines
sadhes104715373sadh_es
salines74029413salines
sanes55649073sa__nes
saphena1235863saphena
saphenas1345713saphenas
sapiens9310173sapiens
sapotes9313943sapotes
sashes94728483sash_es
savines104417633savines
sophies12314613sophies
spahees1238263spahees
sphenes123013163_sphenes
spines85132033_spines
supines94216383supines
taches114224173tach_es
tapes75838603tap__es
tapholes1339623tapholes
tapises92914013tapises
tophes115218423toph_es
vahines133410523vahines
valines104520213valines
vanes85130973va__nes
wahines133111173wahines
wanes85040883wa__nes
washes124425493wash_es
yapons114411773yapon_s

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.440406115.9
2DLD Change Limit1340272806.82619634.8
3Display Results2802800.1102545.5
 (SQL Overall)1786912807.37624226.0
 
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.