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

195 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
chubby184412(None) 
clubby1534681clubby
cubby145212111c_ubby
hubby155011391_hubby
bubby115013922_bubby
cabby145314552c_abby
chub115516412chu_b_
chubbily2042912chubbily
chubs125412622chu_bs
chucky20418002chucky
chuffy20445862chuffy
chummy18385892chummy
chunky18468272chunky
cobby145516402c_obby
crabby15346752crabby
crumby15408112crumby
grubby14324502grubby
hobby155913722_hobby
hubbly16478412_hubbly
knubby1742782knubby
nubby125011022_nubby
rubby124413852_rubby
scrubby1642802scrubby
shabby1635802shabby
shrubby1742362shrubby
snubby1344532snubby
stubby1345042stubby
tubby124511392_tubby
blabby1234813blabby
blebby1233743blebby
bobby114814653_bobby
brumby15385953brumby
bubba84311793_bubba
bubbly124110353_bubbly
busby126113293_busby
carboy134914183carboy
causey113513273causey
chabuk1734673chabuk
chaffy20456473chaffy
chalky18468773chalky
chally144314293chally
chammy18488953chammy
champy18509613champy
chancy164010863chancy
chanty145215823chanty
charry145012113charry
chary135023133ch_ary
chasmy16468543chasmy
chatty14419363chatty
chay124924873ch__ay
chebec1536963chebec
cheeky18448613cheeky
cheery144913153cheery
cheesy14419193cheesy
cherry144810763cherry
cherty144612473cherty
chesty144610503chesty
chevy16479993ch_evy
chewy165011903ch_ewy
chicly16429203chicly
chilly144113223chilly
chimb144813563chimb_
chimbly1974593chimbly
chimbs153910303chimbs
chinky185610543chinky
chippy18437613chippy
chirpy16498913chirpy
chitty14329433chitty
chivvy20374433chivvy
chivy164810363ch_ivy
chokey184811713chokey
choky175711223ch_oky
choosy14459103choosy
choppy18376293choppy
chromy16309903chromy
chubbier1733893chubbier
chuck164814873chu_ck
chucks174812933chucks
chufa13489113chu_fa
chufas14397673chufas
chuff164812493chu_ff
chuffs17427783chuffs
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
chutes114615763chutes
chutney1533823chutney
club85819473clu_b_
clubbed14307453clubbed
clubber13319593clubber
clubs95415103clu_bs
clumpy15409573clumpy
clumsy13326193clumsy
clunky15447893clunky
cobb106421993c_obb_
cobbs115013983c_obbs
colby124415063c_olby
corby125018533c_orby
county114313323county
cowboy1637063cowboy
cruddy1334193cruddy
crumb114313593crumb_
crumbly16347523crumbly
crumbs12409233crumbs
crummy15365893crummy
crusty114911343crusty
crybaby1941933crybaby
cub76940943c_u_b_
cube85830213c_u_be
cubeb115814653c_ubeb
cubebs12508673c_ubebs
cubed105519703c_ubed
cuber95222533c_uber
cubes95028163c_ubes
cubic114313413c_ubic
cubit94122883c_ubit
cubs85832383c_u_bs
cuddy125111973c_uddy
cully105520463c_ully
cuppy144710383c_uppy
curb86732223c_urb_
curbs94821653c_urbs
curdy115916523c_urdy
curly105321233c_urly
curry105920343c_urry
curvy136013373c_urvy
cushy134412323c_ushy
cutey105819793c_utey
cutty105417223c_utty
daubry12445483daubry
dauby115211223dau_by
dobby136013623_dobby
doubly12328963doubly
flabby1634573flabby
fubsy13589273_fubsy
gabby135512943_gabby
globby1434683globby
grabby14336183grabby
herby134715313_herby
hub86437483_hu_b_
hubbub1243603_hubbub
hubs96027143_hu_bs
huffy174810233_huffy
hulky155312473_hulky
humbly164010523_humbly
humpy155115673_humpy
hunky155417733_hunky
hurly115819293_hurly
hurry114917183_hurry
husky156112563_husky
hussy116812763_hussy
knobby1732713knobby
lobby125113913_lobby
nobby125513453_nobby
nubbly13369673_nubbly
outby10411533_outby
rhumb12438653rhumb_
rhumba13375553rhumba
rhumbs13366773rhumbs
ribby12419673_ribby
rubbly133710613_rubbly
ruby97819943_ru_by
rugby11448133_rugby
scabby1535503scabby
slobby1334803slobby
snobby1334403snobby
squabby2343283squabby
stubbly1444473stubbly
swabby1634353swabby
tabby125213883_tabby
thumb124511283thumb_
thumbs13377443thumbs
thusly1235133thusly
upby1139063__upby
webby1537143_webby
yabby15389743_yabby

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.1531167915.0
2DLD Change Limit1127161956.28317939.8
3Display Results1951950.0633095.2
 (SQL Overall)1786911956.49927495.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.