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

363 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
dolmens1038869(None) 
dolmans10479681dolmans
dolmen93911371dolmen_
doles67843752dol_e_s
dolman95312402dolman_
dolmas95213042dolm_as
dolmenic1344842dolmenic
domes85735562do_me_s
dormers104313922dormers
dormins10311272dormins
dovens104413902do_vens
doyens104810222do_yens
dozens164612462do_zens
omens75618962_o_mens
pollens93713302pollens
abdomens1345243abdo_mens
acumens1136953acumens
ailment9314233ailment
ailments1039433ailments
aliens65619213_aliens
almehs11619493_almehs
almes75126543_alme_s
amens75624843__amens
baleens938473baleens
boles75448603bol_e_s
bolsons969483bolsons
bolters94017803bolters
boomers114115913boomers
boreens9310403boreens
bowmen1399853bowmen_
codens94821013co_dens
coles76055063col_e_s
coleus86818273col_eus
colies84837053colie_s
colins85229043col_ins
colleens1036843colleens
collets93517903collets
collins93419833collins
colones96124433colones
colons86028683col_ons
colters93522443colters
columels1244813columels
columns1136473columns
comers105328083co_mers
comes97246993co_me_s
comets105823583co_mets
commend144010183commend
commends15308463commends
comment1310317703comment
comments142913883comments
commons13311043commons
copens106119963co_pens
cormels113813373cormels
covens114919263co_vens
cowmen13810923cowmen_
cozens176314923co_zens
daemons10269233daemons
daimen92210573daimen_
daimons10249323daimons
dales66439743dal_e_s
dalles74222063dalle_s
daltons8310403daltons
damans94715983d_amans
dames85435853d_ame_s
dammers123214273dammers
damns84916923d_am_ns
dampens12348563dampens
darkens12409873darkens
davens104612913d_avens
deadens93410693deadens
deafens11317253deafens
deepens10307813deepens
deles65139253del_e_s
delimes10314193delime_s
delvers113411993delvers
delves104917083delve_s
demeans1039723d_emeans
dement93825153d_ement
dements103016623d_ements
demes86032693d_eme_s
demons94917723d_emons
dens55945073d___ens
desmans1039003desmans
dholes104914793dhol_e_s
diamins10312213diamins
dickens144410133dickens
diluent8310263diluent
diluents946053diluents
dimers94321093d_imers
dimes85833043d_ime_s
dimmers123811563dimmers
dismes95617673disme_s
dizens164911393d_izens
dobbers123513253dobbers
dobbins12379533dobbins
dobies94422093dobie_s
doblones1136763doblones
doblons1037043doblons
dobsons1036203dobsons
docent92918683do_cent
docents102810803do_cents
dockers143715003dockers
dockets144412243dockets
document1348663document
documents1446523documents
dodders105511793dodders
dodgems12576443dodgems
dodgers105213823dodgers
dodges96119083dodge_s
dodoes85716103dodoe_s
doers65225713do__ers
does56554473do__e_s
doffers14359853doffers
doges75630163do_ge_s
dogeys115510663do_geys
doggers104413433doggers
dogies85022253dogie_s
doglegs1034783doglegs
dogmas105011243dogm_as
doilies84017363doilie_s
dolce85816683dolce__
dole56550003dol_e__
doled75430913dol_e_d
doling84923133dol_ing
dollars83311023dollars
dolled83518073dolle_d
dollies83620983dollies
dolling93817373dolling
dollops10287963dollops
dolls66126923dol__ls
dolma86214173dolm__a
dolmades1245463dolmades
dolors75115313dol_ors
dolours8438823dolours
dolphins1445653dolphins
dols56943053dol___s
dolts65626313dol__ts
domains10510873domains
dome77240733do_me__
domed95423263do_me_d
domine92918253do_mine
domines102918973do_mines
doming104218393do_ming
domino92611493do_mino
dominos103210193do_minos
doms76239573do_m__s
donees74519493do_nees
donjons1536733donjons
donkeys15426663donkeys
donnees84210363donnees
dons56048703do___ns
donzels1735393donzels
doolees83711613doolees
doolies83920713doolie_s
doomed104113293doome_d
dooming113112533dooming
dooms85321343doom__s
doormen1036753doormen_
doozers17419293doozers
dopers95522483do_pers
dopes84935043do_pe_s
dories75232363dorie_s
dormant102814373dormant
dormer94415903dorme_r
dormient1148453dormient
dormin9312313dormin_
dorms85723843dorm__s
dorpers104113173dorpers
dorsels84412573dorsels
dorsers83516303dorsers
dosers75723633do_sers
doses65938503do_se_s
dossels85511603dossels
dossers84516233dossers
dosses76126273dosse_s
doters74423913do_ters
dotes65836693do_te_s
dottels8327783dottels
dotters83715973dotters
doumas95314813doum_as
doums85417643doum__s
dousers84817273dousers
douses74928933douse_s
doven94718553do_ven_
doves94728153do_ve_s
dowels104813343do_wels
dowers104523293do_wers
downers113912773downers
downs94918573do__wns
dowsers115013533dowsers
dowses105718303dowse_s
doxies143917853doxie_s
doyen95014413do_yen_
doyleys14384923doyleys
doylies114512573doylie_s
dozen155017473do_zen_
dozers164815423do_zers
dozes155226303do_ze_s
dromons1038193dromons
dudeens934863dudeens
dulcets1046283dulcets
dulness8307983dulness
dulses73913653dulse_s
duramens1195153duramens
examens1637193examens
filmers124211293filmers
flamens124611063flamens
foamers123812103foamers
foemen11310523foemen_
folders113514393folders
foleys123810463fol_eys
folles93820473folle_s
foment113718303fo_ment
foments122912053fo_ments
foramens1337823foramens
formers128217953formers
formes114623713forme_s
germens1078633germens
glens66519853_gl_ens
golden84411153golden_
golems939323gol_ems
golfers114410083golfers
gomers94116883go_mers
gorhens1137183gorhens
guldens9356573guldens
helmets12309073helmets
hoddens12378803hoddens
hoidens11329083hoidens
holden104113953holden_
holders113715903holders
holes84748653hol_e_s
holies94630033holie_s
hollers103818233hollers
holms105117803holm__s
holpen11299413holpen_
homers114821973ho_mers
homes106938813ho_me_s
homeys145012873ho_meys
hoydens14347403hoydens
hymens1437993_hymens
joles125230833jol_e_s
jolters143711993jolters
lens46146493__l_ens
liens56525503__liens
limens84618033_limens
lodens74315063lo_dens
lollers72713793lollers
lomeins969483lo_meins
loment84021473lo_ment
loments93413473lo_ments
loosens716310953loosens
loudens8368053loudens
lumens85013973_lumens
mildens10339933mildens
molders103315553molders
moles74747923mol_e_s
molies84429513molie_s
molten83311813molten_
molters93816973molters
moment103319683mo_ment
moments113113123mo_ments
momes95134473mo_me_s
moreens939963moreens
morgens10310463morgens
mullens93611313mullens
nomen75621623no_men_
nomes74933123no_me_s
nonmen8412833nonmen_
noumena945633noumena
oddment1145923oddment
oddments1244103oddments
oilmen848313oilmen_
olden65114853_olden_
oleins6313523_oleins
oleos55419683_ol_eos
oles46453473_ol_e_s
omen66828183_o_men_
omers76923193_o_mers
opens76118553_o_pens
ormers84316143_ormers
ovens86217453_o_vens
palmers113513623palmers
pelmets11309693pelmets
polders103617373polders
poleis86018353pol_eis
polers84225643pol_ers
poles75351003pol_e_s
poleyns1236113poleyns
polies84034583polie_s
pollees93215333pollees
pollen83416453pollen_
pollers93420023pollers
polyene1259363polyene
polyenes13510063polyenes
polymers1538333polymers
pomes94833933po_me_s
pommels13235783pommels
poteens92910883poteens
potmen102713093potmen_
roamers93713463roamers
rodmen939713rodmen_
roles56747983rol_e_s
rolfers104011813rolfers
rollers73117473rollers
romans84620243ro_mans
romeos84013173ro_meos
roomers95416413roomers
rouens64814443ro_uens
rowens94515303ro_wens
rumens83611813_rumens
salmons93713263salmons
semens84616973_semens
siemens938413siemens
slovens10316573slovens
socmen1039193socmen_
soddens9348413soddens
softens10347623softens
solans64122493sol_ans
soldans83210403soldans
solders83517773solders
solemn838643solemn_
soles55547923sol_e_s
soleus64615613sol_eus
solions7513753solions
solons65120023sol_ons
solvent10310833solvent
solvents1136763solvents
solvers104414253solvers
solves95018223solve_s
somans84619303so_mans
sowens93613153so_wens
spleens937103spleens
stamens93411483stamens
stollens835293stollens
tokens104711563to_kens
tolanes74216313tolanes
tolans64319273tol_ans
toles55147133tol_e_s
tollers73217463tollers
tollmen935733tollmen_
toluene736463toluene
toluenes836763toluenes
tomans85419133to_mans
tomes76037383to_me_s
torment9316173torment
torments10310453torments
voles86234043vol_e_s
volleys13316643volleys
voltes94915583volte_s
volumes12298233volume_s
vomers115614943vo_mers
wolfers13409633wolfers
wolvers13349313wolvers
wolves124510853wolve_s
womans114613653wo_mans
women104619253wo_men_
woolens10398843woolens
woollens1144093woollens
woolmen1234973woolmen_
wormers124012573wormers
worsens104610263worsens
wovens12449833wo_vens
yamens114010823_yamens

Search took 7 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.423422437.4
2DLD Change Limit1340273635.89022755.0
3Display Results3633630.1232951.2
 (SQL Overall)1786913636.43627764.3
 
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.