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

254 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
chummy1838589(None) 
chammy18488951chammy
crummy15365891crummy
champy18509612champy
chasmy16468542chasmy
chromy16309902chromy
chubby1844122chubby
chucky20418002chucky
chuffy20445862chuffy
chum116318002chu_m_
chummed17396442chummed
chummily2042842chummily
chump145315442chu_mp
chumps154313822chumps
chums125015832chu_ms
chunky18468272chunky
clammy15356332clammy
clumpy15409572clumpy
clumsy13326192clumsy
commy144712642c_ommy
crumby15408112crumby
dummy134712782_dummy
gummy135413652_gummy
hammy155113432_hammy
humpy155115672_humpy
mummy114913622_mummy
plummy15375662plummy
rummy124212412_rummy
scummy15265222scummy
shammy16388502shammy
shimmy16306412shimmy
slummy13325862slummy
thrummy1742172thrummy
tummy124711992_tummy
whammy19375292whammy
yummy15429152_yummy
brumby15385953brumby
bumpy144715053_bumpy
calmly1337613calmly
calumny1443863calumny
campy145116183c_ampy
causey113513273causey
chacma1537903chacma
chaffy20456473chaffy
chalky18468773chalky
chally144314293chally
cham115532313ch_am_
champ145017963ch_amp
champs154915683champs
chams126028503ch_ams
chancy164010863chancy
chanty145215823chanty
charm126124663charm_
charms135218843charms
charry145012113charry
chary135023133ch_ary
chasm125518793chasm_
chasms135513143chasms
chatty14419363chatty
chay124924873ch__ay
cheeky18448613cheeky
cheery144913153cheery
cheesy14419193cheesy
chemic153012093chemic
chemo12313633ch_emo
chemos13311723chemos
cherry144810763cherry
cherty144612473cherty
chesty144610503chesty
chevy16479993ch_evy
chewy165011903ch_ewy
chicly16429203chicly
chilly144113223chilly
chimar133911473chimar
chimb144813563ch_imb
chimbly1974593chimbly
chimbs153910303chimbs
chime125322593ch_ime
chimed145814833chimed
chimer135517203chimer
chimes134922573chimes
chimla1337593chimla
chimley1785163chimley
chimney1795483chimney
chimp145216473ch_imp
chimps155713663chimps
chinky185610543chinky
chippy18437613chippy
chirm125317063chirm_
chirms135113983chirms
chirpy16498913chirpy
chitty14329433chitty
chivvy20374433chivvy
chivy164810363ch_ivy
chlamys1733783chlamys
chokey184811713chokey
choky175711223ch_oky
chomp144815663ch_omp
chomps155112223chomps
choosy14459103choosy
choppy18376293choppy
chroma132912473chroma
chrome133214813chrome
chromo132811013chromo
chromyl17275233chromyl
chub115516413chu__b
chubs125412623chu_bs
chuck164814873chu_ck
chucks174812933chucks
chufa13489113chu_fa
chufas14397673chufas
chuff164812493chu_ff
chuffs17427783chuffs
chug105914113chu__g
chugs115511943chu_gs
chukar1534633chukar
chukka1433013chukka
chummier1734513chummier
chumming18366203chumming
chumped17379493chumped
chunk144812383chu_nk
chunks154210333chunks
chuppa1543973chuppa
church1636483church
churchy2044183churchy
churl105913883chu_rl
churls115411073churls
churn105113103chu_rn
churns114910233churns
churr104512853chu_rr
churro11448353churro
churrs115111513churrs
chute104316463chu_te
chuted124611843chuted
chutes114615773chutes
chutney1533823chutney
chyme156512503ch_yme
chymes165912153chymes
chymic18317883chymic
clubby1534683clubby
clump115517453clu_mp
clumps1215314643clumps
clunky15447893clunky
comfy153710213c_omfy
comma114514793c_omma
county114313323county
crampy154710993crampy
creamy134811363creamy
crimpy15489393crimpy
cruddy1334193cruddy
crumb114313593cru_mb
crumbly16347523crumbly
crumbs12409233crumbs
crummie1336153crummie
crump115616423cru_mp
crumply16336093crumply
crumps124514343crumps
crusty114911343crusty
cubby145212123c_ubby
cuddy125111973c_uddy
cully105520463c_ully
culm85822383c_ulm_
culms95314193c_ulms
cum76440163c_u_m_
cumin94616973c_umin
cummer124414593c_ummer
cummin1288783c_ummin
cuppy144710383c_uppy
curdy115916523c_urdy
curly105321233c_urly
curry105920343c_urry
curvy136013373c_urvy
cushy134412323c_ushy
cutey105819793c_utey
cutty105417223c_utty
drumly1235703drumly
dumky154511343_dumky
dumpy135414753_dumpy
emmy116013243__emmy
frumpy16466883frumpy
fumy127118583_fu_my
gammy135514893_gammy
gemmy135211053_gemmy
glumly12356623glumly
glumpy14527193glumpy
gremmy1454473gremmy
grumpy14498153grumpy
gumma105313103_gumma
haulmy14455553haulmy
hempy154912763_hempy
hmm106218993_h_mm_
homey135924843_homey
homy126623223_h_omy
hubby155011403_hubby
huffy174810233_huffy
hulky155312473_hulky
hum85542933_hu_m_
human102716033_human
humbly164010523_humbly
humic124113243_humic
humid114213763_humid
hummed144812673_hummed
hummer133615273_hummer
hummus1336243_hummus
humor101110513_humor
hump116228723_hu_mp
humph155712213_humph
humps126322803_humps
hums96831423_hu_ms
humus106215073_humus
hunky155417733_hunky
hurly115819293_hurly
hurry114917183_hurry
husky156112563_husky
hussy116812763_hussy
immy114611833__immy
jammy194810193_jammy
jemmy19498553_jemmy
jimmy19538503_jimmy
jumpy195712813_jumpy
lumpy126615913_lumpy
mammy115215163_mammy
mommy114010753_mommy
mumm75718863_mumm_
mumms85513153_mumms
plumy124213233plu_my
pommy14449863_pommy
rammy124312493_rammy
rheumy1433353rheumy
rhumb12438653rhu_mb
rhumba13375553rhumba
rhumbs13366773rhumbs
schlumpy2041873schlumpy
shamoy14379913shamoy
shlumpy1742863shlumpy
spumy124610363spu_my
stemmy13417033stemmy
stumpy13458133stumpy
summa94713313_summa
swimmy16234353swimmy
tammy124013223_tammy
thumb124511283thu_mb
thumbs13377443thumbs
thump126211573thu_mp
thumps13449353thumps
thusly1235133thusly
thymey17426313thymey
thymy16437923th_ymy
tommy124712233_tommy
umm711921263__umm_
whammo16405193whammo
whimsy17375223whimsy
whump154910043whu_mp
whumps16427093whumps

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 Filter1786911127160.390458182.1
2DLD Change Limit1127162545.56020272.7
3Display Results2542540.0803175.0
 (SQL Overall)1786912546.03029633.7
 
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.