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

271 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
pommels1323578(None) 
pommel12277451pommel_
pummels13236541pummels
compels133210882compels
cormels113813372cormels
kummels15234792kummels
pomelo10238662po_melo
pomelos11218132po_melos
pomes94833932po_me_s
pommee122813282pomme_e
pommeled1543102pommeled
pommies133712842pommies
pummel12278042pummel_
pummelo13284232pummelo
pummelos14223102pummelos
trommels12254332trommels
boatels93510233boatels
bombers134512593bombers
bombes124916823bombe_s
boomers114115913boomers
bordels103911973bordels
botels84815803bo_tels
bowels114315593bo_wels
bummers133712443bummers
camels105217083_camels
columels1244813columels
combers134516623combers
combes125321733combe_s
comely134213733co_mely
comers105328083co_mers
comes97246993co_me_s
comets105823583co_mets
commas124814573comm_as
commend144010183commend
commends15308463commends
comment1310317703comment
comments142913883comments
commies133718453commies
commits133812383commits
commons13311043commons
compel124412893compel_
comtes106222813comte_s
corbels113813593corbels
cormel103815603cormel_
cornels94716663cornels
cummers133713483cummers
dammers123214273dammers
damsels10126703damsels
dimmers123811563dimmers
dolmens10388693dolmens
domes85735563do_me_s
donzels1735393donzels
dormers104313923dormers
dorsels84412573dorsels
dossels85511603dossels
dottels8327783dottels
dowels104813343do_wels
emmers104013223_emmers
emmets10349153_emmets
enamels9128163enamels
femmes135410213femme_s
foamers123812103foamers
formals123312893formals
formers128217953formers
formes114623713forme_s
formols12299413formols
formyls15235703formyls
gammers123214563gammers
gimels938893_gimels
gimmals12225823gimmals
gimmes113010903gimme_s
gomerels1144563gomerels
gomers94116883go_mers
gospels1035593gospels
grommets13234663grommets
gummers123712203gummers
hammals14409223hammals
hammers144216063hammers
hemmers143310843hemmers
homely145313173ho_mely
homers114821973ho_mers
homes106938813ho_me_s
homeys145012873ho_meys
homies114524723homie_s
hommos13128503homm_os
hosels94218603ho_sels
hostels103712313hostels
hotels94515513ho_tels
housels105312133housels
hovels125413333ho_vels
hummers143813063hummers
impels10389523_impels
ipomoeas1242733ipomoeas
jammers183710703jammers
koels94613903ko__els
kummel14266173kummel_
limmers113413083limmers
losels64714583lo_sels
mammals10389273mammals
mammees104411143mammees
mammers104615693mammers
mammets103911113mammets
mammeys13376723mammeys
mels65941533___mels
models94216353mo_dels
mohels115011323mo_hels
momes95134473mo_me_s
mommas94110653momm_as
mommies103912273mommies
momsers113810843momsers
momzers20367133momzers
morels84820013mo_rels
morsels94112653morsels
motels83616893mo_tels
mummers103712843mummers
noels56418703no__els
nombles113212343nombles
nomes74933123no_me_s
normals92510903normals
novels95512503no_vels
ombers104214403_ombers
omens75618963_o_mens
omers76923193_o_mers
oriels64914623_oriels
ormers84316143_ormers
osmols8137313_osmols
ousels64815273_ousels
ouzels15408703_ouzels
palmers113513623palmers
pampers133615933pampers
panels84716523p_anels
parcels113712663parcels
parrels94713493parrels
passels93913023passels
pastels95215183pastels
peels75226423p__eels
pelmets11309693pelmets
pencels113610053pencels
petrels9279373petrels
pimples133012423pimples
pixels15478533p_ixels
plumes104318133plume_s
plummets14304773plummets
pockets154612253pockets
podsols1056513podsols
podzols1934683podzols
poems95715553po__ems
poetess938933poetess
poets76024443po__ets
pogeys124110353po_geys
pogies94123543pogie_s
poisers94214433poisers
poises84226543poise_s
poitrels1035243poitrels
pokers124617923po_kers
pokes116133013po_ke_s
pokeys15529513po_keys
pokies125921333pokie_s
polders103617373polders
poleis86018353po_leis
polers84225643po_lers
poles75351003po_le_s
polies84034583polie_s
pollees93215333pollees
pollens93713303pollens
pollers93420023pollers
polls74627723po__lls
pols66044563po___ls
polymers1538333polymers
polyols1238493polyols
pomaces132712123pomaces
pomades123711733pomades
pome85636693po_me__
pomfrets1543033pomfrets
pommeling1643873pommeling
pommelled1643083pommelled
pommie123710503pomm_ie
pommy14449863pomm__y
pomos95321583po_m_os
pompoms1535333pompoms
pompons1338553pompons
pompous1338063pompous
pomps115316193po_m_ps
poms87037743po_m__s
ponces104720843ponce_s
ponders103618843ponders
pones74547043po_ne_s
pongees104212543pongees
ponies84833463ponie_s
pontes83627853ponte_s
pontils9312213pontils
poodles103013513poodles
poolers94217423poolers
pools74427703po__ols
pooves113914713poove_s
popes95933813po_pe_s
poppers103414863poppers
poppets10338853poppets
popples103011873popples
pores75849033po_re_s
porkers134314933porkers
portals94015563portals
porters93722703porters
posers84223973po_sers
poses74642763po_se_s
posies84431433posie_s
posoles9314883posoles
posses85128803posse_s
possess9419123possess
possets94212773possets
postals93716373postals
posters93928013posters
poteens92910883poteens
potfuls1236293potfuls
pothers123818623pothers
potmen102713093potme_n
potters94024343potters
pottles93816983pottles
potzers184010543potzers
pourers93513673pourers
pouters94221873pouters
powders134111553powders
powers113822323po_wers
powters124015663powters
poxes145325723po_xe_s
pozoles1839063pozoles
premeds12389593premeds
primely1457723primely
primers114215673primers
primes104225263prime_s
propels113412843propels
pumelo10257113p_umelo
pumelos11196093p_umelos
pummeled1543373pummeled
pumpers133113673pumpers
rammers113715043rammers
rimmers113812883rimmers
roamers93713463roamers
romeos84013173ro_meos
rompers113412243rompers
rondels82510053rondels
ronnels7318613ronnels
roomers95416413roomers
rowels94515453ro_wels
rummers113513653rummers
samiels939763samiels
simmers113314613simmers
simnels976103simnels
sorels63921163so_rels
sorrels7310723sorrels
spammers14378693spammers
stammels12495563stammels
summers113616503summers
tomes76037383to_me_s
tommed113310143tomme_d
tommies113812983tommies
towels94314643to_wels
tramels93812493tramels
trammels12295413trammels
trommel11315363trommel_
umbels104510593_umbels
vomers115614943vo_mers
vowels124410483vo_wels
wadmels1334303wadmels
wommera14144063wommera
wommeras15133773wommeras
wormers124012573wormers
wormils1236733wormils
yammers143410323yammers
yodels104610073yo_dels
yokels13488063yo_kels

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.406440125.6
2DLD Change Limit1340272716.45320769.7
3Display Results2712710.0962822.9
 (SQL Overall)1786912716.95525692.5
 
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.