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

292 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
pompons133855(None) 
pompoms1535331pompoms
pompon1238941pompon_
pompous1338061pompous
commons13311042commons
compone136517192compone
compony1613011912compony
compos124818802compo_s
coupons112710562coupons
poisons9310352poisons
pomos95321582pom_o_s
pompano1345202pompano
pompanos1445242pompanos
pompom1436492pompo_m
pomps115316192pomp__s
pontons93315552pontons
poons75430972po__ons
potions93417422potions
tampons112711562tampons
tompions12267002tompions
youpons12265982youpons
bolsons969483bolsons
bonbons1139333bonbons
boons75031913bo__ons
borons85520543bo_rons
bosons85016653bo_sons
bostons9312903bostons
boutons9310783boutons
bowpots1446023bowpots
camions113916133camions
campions143511293campions
campong14318123campong
campongs15356123campongs
campos125217953campo_s
capons104119503_capons
cocoons11310563cocoons
codons96119463co_dons
cogons96818113co_gons
colons86028683co_lons
combos125316613combo_s
common12310803common_
comous10816503com_ous
company1619711143company
compas125817063comp_as
compass13379563compass
compels133210883compels
compend144010303compend
compends15378253compends
comping143518593comping
complins14313113complins
complots1438163complots
compo115318573compo__
comport133616843comport
comports143411983comports
compose135716663compose
composes145017113composes
compost134515353compost
composts144210913composts
compote135616463compote
compotes144716513compotes
compound1555993compound
compounds1654503compounds
comps115526053comp__s
compts125216653comp_ts
coons76737283co__ons
copens106119963co_pens
cordons104415763cordons
cottons9312193cottons
coupon102810993coupon_
coypous14248813coypous
crampons1436643crampons
crepons1139323crepons
dampens12348563dampens
damsons1038013damsons
demons94917723dem_ons
doblons1037043doblons
dobsons1036203dobsons
domains10510873domains
dominos103210193dominos
donjons1536733donjons
dromons1038193drom_ons
foisons1047613foisons
gammons1237973gammons
gipons9389603_gipons
gnomons1035753gnom_ons
godsons966663godsons
gombos114311093gombo_s
goons65326773go__ons
gorgons938853gorgons
hommos13128503hommo_s
homos105921783hom_o_s
hoopoes121212483hoopoes
hoopoos1298543hoopoos
impone103011863_impone
impones112712253_impones
jomon14610083jom_on_
joypops2162603joypops
jupons15377803_jupons
kampong16294933kampong
kampongs17293033kampongs
lampions12277973lampions
lampoons12266873lampoons
lemons84415053lem_ons
logions86211293logions
logons79818173lo_gons
lomeins969483lomeins
loons55731723lo__ons
lotions74614763lotions
lumpens11298263lumpens
mammons1048513mammons
mons68152263__m_ons
moons75331003__moons
morions94014643morions
morons84919543mo_rons
motions94215003motions
moutons9410313moutons
muons75816173__muons
nomos75919743nom_o_s
noons54125283no__ons
notions74014483notions
odeons739023_odeons
omens75618963_om_ens
onions64016433_onions
oompahs1434263oompahs
oomphs1344723oomp_hs
opens76118553_o_pens
operons91411743operons
options93810603options
orlons6411013_orlons
orpins83614163_orpins
paeons83915523p_aeons
pampas124913993pamp_as
pampeans1444703pampeans
pampers133615933pampers
pappous1057463pappous
pardons103817623pardons
parsons93516873parsons
partons94620513partons
patrons93818103patrons
pennons939713pennons
peons75327183p__eons
pepos96620083p_epo_s
pereons92815003pereons
perrons93115483perrons
persons93717013persons
phonons123310253phonons
phons105221143p__hons
photons123814433photons
phytons15319063phytons
pigeons1039183pigeons
pigpens1235503pigpens
pimping143812123pimping
pimples133012423pimples
pimps114616983pimp__s
pinions93413603pinions
pinons86019943p_inons
pinyons12299003pinyons
pions75826393p__ions
pippins10319753pippins
pistons93016373pistons
pitons85319043p_itons
pleons84213343p_leons
plosions1038023plosions
plumpens14304953plumpens
plutons938343plutons
poboys1397313po_boys
pocosons1266103pocosons
podsols1056513podsols
podzols1934683podzols
pogroms1237643pogroms
poison8312223poison_
polarons1039863polarons
poleyns1236113poleyns
polios84019723polio_s
pollens93713303pollens
polos76129913po_lo_s
polygons1447723polygons
polyols1238493polyols
polypods1647113polypods
polypous1547983polypous
pomaces132712123pomaces
pomades123711733pomades
pomelos11218133pomelos
pomes94833933pom__es
pommels13235783pommels
pommies133712843pommies
pomo85828453pom_o__
pomp106225463pomp___
pompously1844353pompously
poms87037743pom___s
pons65850603___pons
ponton83217643ponton_
pontoons10279313pontoons
poods85124753po__ods
poofs105222793po__ofs
poohs103915713po__ohs
pools74427703po__ols
poon67341263po__on_
pooping123615443pooping
poops94422413po__ops
poos65949113po__o_s
popcorns1444023popcorns
popes95933813po_p_es
popguns1234023popguns
poplins11313153poplins
poppas93710713po_ppas
poppers103414863poppers
poppets10338853poppets
poppies102816193poppies
popping113715413popping
popples103011873popples
pops86340953po_p__s
pornos85015253porno_s
porns75527343po__rns
porous84419483po_rous
porpoise1248083porpoise
portions10514413portions
postins93721203postins
postops11311713postops
postpone1248693postpone
postpones1348833postpones
potboys1475273potboys
poteens92910883poteens
pothos114214693potho_s
potion84519573potion_
potpies113116173potpies
pottos84615873potto_s
powwows1442853powwows
poyous112911623po_yous
prions84317783p_rions
prisons9313223prisons
promos105116423prom_o_s
prompts1337473promp_ts
propone112716303propone
propones122516963propones
protons93118003protons
psammons1442783psammons
ptomains1246053ptomains
pulpous1177013pulpous
pumpers133113673pumpers
pumping144213553pumping
pumpkins1843853pumpkins
pumps115520603pump__s
putons83515153p_utons
pylons113011243p_ylons
pythons1537363pythons
rampions12248023rampions
ramsons939563ramsons
romanos94311483romanos
romans84620243rom_ans
romeos84013173romeo_s
rompers113412243rompers
romping123113033romping
romps94617543romp__s
ronions73313343ronions
ronyons10258433ronyons
sampans112411003sampans
simoons937943simoons
solions7513753solions
solons65120023so_lons
somans84619303som_ans
someone938813someone
someones1039063someones
somoni8310743som_oni
sopors85215203so_pors
soupcons1244373soupcons
sponsons1045813sponsons
spoons84116023spo__ons
summons1158003summons
tampans113310983tampans
tampions12358123tampions
tampon102911233tampon_
tarpons92612213tarpons
tempos103812293tempo_s
tomans85419133tom_ans
tomboys1435713tomboys
tomcods1234873tomcods
tompion11247103tompion_
toons55027533to__ons
topos75726393to_po_s
torpors939383torpors
toyons95512133to_yons
tympans14236813tympans
voudons1135323voudons
weapons12278603weapons
womans114613653wom_ans
wontons103310533wontons
yapons114411773_yapons
yaupons12345683yaupons
youpon11366003youpon_
yupons11398353_yupons
zoons144919693zo__ons

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 Limit1340272927.15618729.3
3Display Results2922920.0933139.8
 (SQL Overall)1786912927.65523343.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.