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

224 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
chuffy2044586(None) 
chaffy20456471chaffy
chuff164812491chuff_
chuffs17427781chuffs
huffy174810231_huffy
buffy165013372_buffy
chaff165016282chaff_
chaffs17459612chaffs
chubby1844122chubby
chucky20418002chucky
chufa13489112chu_fa
chufas14397672chufas
chuffed19316642chuffed
chuffer18337142chuffer
chummy18385892chummy
chunky18468272chunky
cliffy17435242cliffy
cuff125327992c_uff_
cuffs135017492c_uffs
fluffy14315782fluffy
gruffy16396012gruffy
huff135623842_huff_
huffs144514742_huffs
pouffy17395882pouffy
puffy164410752_puffy
scruffy1842642scruffy
snuffy15356242snuffy
stuffy15317082stuffy
baffy165511923_baffy
biffy164711133_biffy
bluff134413833bluff_
bluffly1833433bluffly
bluffs14388373bluffs
bouffe14438313bouffe
buff125229863_buff_
buffi136112203_buffi
buffo135112183_buffo
buffs135519513_buffs
caff125631673c_aff_
caffs135417373c_affs
casefy1436273casefy
causey113513273causey
chafe135117353ch_afe
chafed154813913chafed
chafer144714573chafer
chafes145017913chafes
chaffed19387703chaffed
chaffer18389473chaffer
chalky18468773chalky
chally144314293chally
chammy18488953chammy
champy18509613champy
chancy164010863chancy
chanty145215823chanty
charry145012113charry
chary135023133ch_ary
chasmy16468543chasmy
chatty14419363chatty
chaufer15347943chaufer
chauffer19263793chauffer
chay124924873ch__ay
cheeky18448613cheeky
cheery144913153cheery
cheesy14419193cheesy
chef125125623ch_ef_
chefed155010563chefed
cheffed19335863cheffed
chefs136214663ch_efs
cherry144810763cherry
cherty144612473cherty
chesty144610503chesty
chevy16479993ch_evy
chewy165011903ch_ewy
chicly16429203chicly
chief134419483chief_
chiefly1834103chiefly
chiefs14509653chiefs
chiffon1844053chiffon
chilly144113223chilly
chinky185610543chinky
chippy18437613chippy
chirpy16498913chirpy
chitty14329433chitty
chivvy20374433chivvy
chivy164810363ch_ivy
chokey184811713chokey
choky175711223ch_oky
choosy14459103choosy
choppy18376293choppy
chromy16309903chromy
chub115516413chu__b
chubs125412623chu_bs
chuck164814873chu_ck
chucks174812933chucks
chuffest1944193chuffest
chuffier1934543chuffier
chuffing2055043chuffing
chug105914113chu__g
chugs115511943chu_gs
chukar1534633chukar
chukka1433013chukka
chum116318003chu__m
chump145315443chu_mp
chumps154313823chumps
chums125015833chu_ms
chunk144812383chu_nk
chunks154210333chunks
chuppa1543973chuppa
church1636483church
churchy2044183churchy
churl105913883chu_rl
churls115411073churls
churn105113103chu_rn
churns114910233churns
churr104512853chu_rr
churro11448353churro
churrs115111513churrs
chute104316463chu_te
chuted124611843chuted
chutes114615773chutes
chutney1533823chutney
citify1437443citify
cliff135917133cliff_
cliffs14477593cliffs
clubby1534683clubby
clumpy15409573clumpy
clumsy13326193clumsy
clunky15447893clunky
codify1537163codify
coff126930783c_off_
coffs134916303c_offs
coiffe1447043coiffe
comfy153710213c_omfy
county114313323county
crafty14478913crafty
crucify1744063crucify
cruddy1334193cruddy
crumby15408113crumby
crummy15365893crummy
crusty114911343crusty
cubby145212123c_ubby
cuddy125111973c_uddy
cuffed154311213c_uffed
cuif96529143c_uif_
cuifs104814693c_uifs
cully105520463c_ully
cuppy144710383c_uppy
curdy115916523c_urdy
curf97538783c_urf_
curfs105122143c_urfs
curly105321233c_urly
curry105920343c_urry
curvy136013373c_urvy
cushy134412323c_ushy
cutey105819793c_utey
cutty105417223c_utty
daffy155510283_daffy
draffy16486633draffy
duff114326643_duff_
duffs125216623_duffs
fluff103913613fluff_
fluffs11347783fluffs
gruff124712143gruff_
gruffly17413893gruffly
gruffs13337453gruffs
guff114624933_guff_
guffs124414823_guffs
gulfy124612003_gulfy
hefty146112133_hefty
hubby155011403_hubby
huffed163710153_huffed
huffily1934693_huffily
hulky155312473_hulky
humpy155115673_humpy
hunky155417733_hunky
hurly115819293_hurly
hurry114917183_hurry
husky156112563_husky
hussy116812763_hussy
iffy135312283__iffy
jiffy21458313_jiffy
luff104426703_luff_
luffa11409023_luffa
luffs114516283_luffs
miffy163910203_miffy
muff124723863_muff_
muffs134114213_muffs
pouff135215423pouff_
pouffe14448263pouffe
pouffs14418123pouffs
puff125525433_puff_
puffs134114933_puffs
ruff105127653_ruff_
ruffe114713813_ruffe
ruffly15336673_ruffly
ruffs114516743_ruffs
scruff1437963scruff_
scruffs1554173scruffs
scuff133914893scuff_
scuffs14419053scuffs
scurfy14338763scurfy
shifty15409263shifty
shuffle16276923shuffle
sluff114016813sluff_
sluffs12349583sluffs
sniffy15337193sniffy
snuff113514043snuff_
snuffly16305203snuffly
snuffs12358533snuffs
spiffy17326223spiffy
squiffy2542573squiffy
stuff113817053stuff_
stuffs123810223stuffs
surfy115319473_surfy
taffy145110823_taffy
thusly1235133thusly
toffy145310283_toffy
truffe1276233truffe
tuff104528523_tuff_
tuffs115118263_tuffs
tufty114810413_tufty
turfy114315403_turfy
whiff17310063whiff_
whiffs1835083whiffs

Search took 5 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.373479064.3
2DLD Change Limit1127162244.51624959.3
3Display Results2242240.0762947.4
 (SQL Overall)1786912244.96535990.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.