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

381 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
damsels1012671(None) 
damosels11195241damosels
damsel9148031damsel_
camels105217082cam_els
daises74318982daise_s
dames85435852dam_e_s
dammers123214272dammers
damners104112112damners
damosel10126702damosel_
damozels20133172damozels
dampens12348562dampens
dampers123915692dampers
damsons1038012damsons
darnels83710432darnels
diesels8429142diesels
dorsels84412582dorsels
dossels85511612dossels
easels65914552ea_sels
hansels104011662hansels
hassels104311022hassels
passels93913022passels
samiels939762samiels
tassels74510852tassels
abseils935973_abseils
aisles64721143_aisles
ambers104519583_ambers
ambles105121863_ambles
ameers84015573_ameers
amens75624843_am_ens
amies76837693_amie_s
amoles84122193_amoles
ampuls1098893_ampuls
amusers94610193_amusers
amuses85117943_amuse_s
amyls104512693_am_yls
angels74416173_angels
appels104312793_appels
apses76823913_apse_s
ariels65119373_ariels
arses55733873_arse_s
artels66216233_artels
asses55629283_asse_s
assess65710463_assess
assets65617663_assets
axels126313633_a_xels
baases85218013baase_s
babels105216723ba_bels
bagels95712313ba_gels
barbels114514433barbels
barrels94514363barrels
basely114412313ba_sely
bases75644353ba_se_s
basils85717473ba_sils
basses85428303basse_s
bassets96414823bassets
camails11311753camails
camases114216343camase_s
cambers134017443cambers
camel96822803cam_el_
cameos105818003cam_eos
cames97047313cam_e_s
camises114218463camise_s
camlets114314623camlets
campers134220293campers
cancels114113313cancels
cannels93413363cannels
carcels114516063carcels
carpels115315463carpels
carrels95117303carrels
carses85233653carse_s
cartels94618123cartels
carvels124914593carvels
cases75048383ca_se_s
causals91411183causals
causers94014793causers
causes88026473cause_s
causeys12387223causeys
chisels12219103chisels
compels133210893compels
dabbers123813213dabbers
dabbles124514773dabbles
dabsters1137053dabsters
daces85030683da_ce_s
dackers143417043dackers
dactyls1333913dactyls
daddles104213803daddles
dadoes85616533dadoe_s
daggers103714913daggers
daggles103611913daggles
dagoes85714603dagoe_s
dahls95012283da__hls
daikers124010313daikers
daisies84217093daisies
dales66439743da_le_s
dalles74222063dalle_s
dals57145123da___ls
damagers1237073damagers
damages11511283damages
damans94715983dam_ans
damars93815003dam_ars
damasks1435073damasks
dame77140313dam_e__
dammars12308193dammars
dammed124214793damme_d
dammer114317933damme_r
damned104212913damne_d
damner95213433damne_r
damns84916923dam__ns
damozel19184353damozel_
damped124315583dampe_d
dampen114310593dampe_n
damper114117753dampe_r
dampest12411043dampest
damply14337893dam_ply
dampness1336073dampness
damps105220413dam__ps
dams77444373dam___s
damselfish1961163damselfish
damselfly186793damselfly
damson938063dams_on
dancers103413093dancers
dances95120653dance_s
danders93921183danders
dandles94218533dandles
dangers94818213dangers
dangles93618423dangles
danseur833663danseur
danseurs933433danseurs
danseuse942893danseuse
dapples1238993dapples
darers75921873da_rers
dares66146703da_re_s
darkens12409873darkens
darkeys15356533darkeys
darkles124011933darkles
darnel74312183darnel_
darners83815773darners
darters84017603darters
dartles84014133dartles
dashers115016863dashers
dashes106124983da_shes
dashis104414393da_shis
dassies84418663dassies
daters74827373da_ters
dates65639153da_te_s
daubers104610423daubers
daubes94913703daube_s
davens104612913da_vens
davies105020513davie_s
dawdles12379163dawdles
daybeds14234473daybeds
dazes155024143da_ze_s
dazzles1636413dazzles
deckels14367363deckels
defuels11296983defuels
dels56745473d___els
demes86032693dem_e_s
demies94825803demie_s
demises103719563demise_s
demoses103815833demose_s
densely1146713densely
detassels1042673detassels
devels104313903d_evels
diesel74410403diesel_
dieses75218693diese_s
dimers94321093dim_ers
dimes85833043dim_e_s
dimmers123811563dimmers
dimness1038843dimness
dimples122813213dimples
dismals102010243dismals
dismes95617673disme_s
dispels10310503dispels
disses75225963disse_s
djebels1753293djebels
domes85735563dom_e_s
donzels1735393donzels
dorsals84110853dorsals
dorsel75315503dorsel_
dorsers83516303dorsers
dosers75723633d_osers
doses65938503d_ose_s
dossals8379303dossals
dossel74813643dossel_
dossers84516233dossers
dosses76126273dosse_s
dossils8669773dossils
dottels8327783dottels
dousers84817273dousers
douses74928933douse_s
dowels104813343d_owels
dowsers115013533dowsers
dowses105718303dowse_s
drivels11397923drivels
druses75517253druse_s
duels65619233d__uels
duffels14296453duffels
dulses73913653dulse_s
dumpers123412663dumpers
dynels10536813d_ynels
easel54521113ea_sel_
eases56041613ea_se_s
enamels9128163enam_els
falsely1336013falsely
fames105735923fam_e_s
fardels11389893fardels
farfels13348213farfels
fusels94412453_fusels
gambes116318313gambe_s
gambles124016203gambles
gambols1238593gambols
gambrels1334213gambrels
gamely124711913gam_ely
gamers94420833gam_ers
games86238553gam_e_s
gammers123214563gammers
gases65633993ga_se_s
gassers84714633gassers
gasses75724783gasse_s
gavels105911093ga_vels
gimels938893gim_els
gunsels8338133gunsels
hallels103310133hallels
hamals114816833ham_als
hamauls12387823hamauls
hames106138703ham_e_s
hamlets123211403hamlets
hammals14409233hammals
hammers144216063hammers
hampers143616953hampers
hamsters13710423hamsters
handsels12317253handsels
hansel95214373hansel_
hanses95022633hanse_s
hassel95614213hassel_
hassles103411693hassles
hausens1077633hausens
hawsers13409483hawsers
hawses125113993hawse_s
hazels185710083ha_zels
himself1544293himself
hirsels10128353hirsels
hosels94218613_hosels
housels105312143housels
impels10389523_impels
jambes175914053jambe_s
jammers183710703jammers
kaisers11369273kaisers
kames115024693kam_e_s
kamseen1344013kamseen
kamseens1442823kamseens
kamsins1346963kamsins
kummels15234793kummels
labels84515683la_bels
lambers113817113lambers
lameds94812033lam_eds
lamely114013223lam_ely
lames75445543lam_e_s
lampers113817333lampers
lamsters1099753lamsters
lapels83712043la_pels
lapsers93911053lapsers
lapses85217693lapse_s
lasers64925703la_sers
lases54944763la_se_s
lasses64827593lasse_s
laurels746663laurels
losels64714593_losels
malmseys1541903malmseys
mameys13449523mam_eys
mamies104626243mamie_s
mammals10389273mammals
mammees104411143mammees
mammers104615693mammers
mammets103911113mammets
mammeys13376723mammeys
mamzers20409163mamzers
mangels103614493mangels
manses84225513manse_s
mantels94515043mantels
marcels113212373marcels
marses84827113marse_s
marvels123810093marvels
masers84623453ma_sers
masses85028713masse_s
mels65941533__m_els
missels94614813missels
momsers113810853momsers
morsels94112663morsels
mussels9419843mussels
namely113711323nam_ely
namers84517333nam_ers
names74833363nam_e_s
nasals63312463na_sals
nauseas735993nauseas
navels95712693na_vels
oases55330983oa_se_s
ousels64815283_ousels
pampers133615933pampers
panels84716523pa_nels
parcels113712663parcels
parrels94713493parrels
parsecs11429923parsecs
parsers94118153parsers
parses85534703parse_s
paseos88015813pa_seos
pases75346503pa_se_s
passel85117003passel_
passers94717753passers
passes86030473passe_s
pastels95215183pastels
pausers94113223pausers
pauses84621473pause_s
pommels13235793pommels
pummels13236543pummels
raisers73617393raisers
raises64826543raise_s
rambles113118313rambles
ramees84620893ram_ees
ramets83517393ram_ets
ramies84630463ramie_s
ramjets1635163ramjets
rammers113715043rammers
ramosely1344233ramosely
ramsons939563ramsons
ramtils938413ramtils
rappels11448803rappels
rasers64526783ra_sers
rases55447213ra_se_s
rassles73513923rassles
ratels64518213ra_tels
ravels94717073ra_vels
sambals115213483sambals
sameks12409323sam_eks
samiel8313333samiel_
samisens1035483samisens
samlets93813553samlets
samples112815453samples
samshus12125353samshus
sanseis73011603sanseis
sarsens7311393sarsens
sasses64124393sasse_s
saurels749303saurels
sels46345983___sels
simnels976103simnels
stammels12495563stammels
taels56822073ta__els
tahsils1035053tahsils
tamales93216153tamales
tamals84116633tam_als
tamely113711953tam_ely
tamers84224033tam_ers
tames75242013tam_e_s
tamises92715973tamise_s
tampers113516743tampers
tarsals72512603tarsals
tassel66014773tassel_
tasses64826763tasse_s
tassets75012773tassets
tawses94913193tawse_s
teasels74311313teasels
tinsels738373tinsels
tramels93812493tram_els
trammels12295413trammels
umbels104510593_umbels
vakeels14113733vakeels
valses94514613valse_s
vamoses1239153vamose_s
vampers143111623vampers
vases84626263va_se_s
vassals1057953vassals
vessels1035933vessels
wadmels1334303wadmels
wadsets1136443wadsets
wambles143714023wambles
wames106432803wam_e_s
wamuses1237023wamuse_s
warsles103413643warsles
weasels10468503weasels
yamens114010823yam_ens
yammers143410323yammers

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.406440125.6
2DLD Change Limit1340273816.98619185.1
3Display Results3813810.1402721.4
 (SQL Overall)1786913817.53223724.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.