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

494 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
cheesy1441919(None) 
cheeky18448611cheeky
cheery144913151cheery
cheese113812761cheese
bheesty1542492bheesty
cees65941592c_ees_
cheek145115712chee_k
cheeks154712782cheeks
cheep125416502chee_p
cheeps135312912cheeps
cheer105420382chee_r
cheerly15417602cheerly
cheero114712932cheero
cheers114518912cheers
cheesed133910682cheesed
cheeses123613102cheeses
cheesily1654412cheesily
chefs136214662chefs_
cherry144810762cherry
cherty144612472cherty
chess105016922ch_ess
chest104926142ch_est
chesty144610502chesty
chevy16479992ch_evy
chews135418512chews_
chewy165011902ch_ewy
choosy14459102choosy
creasy114612302creasy
creepy13418802creepy
creese84014332creese
creesh11328332creesh
cressy11439112cressy
cutesy114810732cutesy
ghees95215552ghees_
heresy125011232_heresy
sheeny124912192sheeny
sheesh1237812sheesh
wheezy24244522wheezy
achenes12313493achenes_
aches106132293ach_es_
achiest12315183achiest
ackees124914573ackees_
akees96119243akees_
beefy135313833_beefy
beery105220123_beery
bees65453383_bees_
behest11314613behest
bluesy11448983bluesy
brees75632553brees_
breezy20295853breezy
cades85440733cades_
cafes106426923cafes_
cages85936013cages_
cagey115917823cage_y
cakes116037673cakes_
cakey145517273cake_y
calesa8412473calesa
cames97047313cames_
canes75350373canes_
capes95441923capes_
cares77369183cares_
caress85720263caress
casefy1436273casefy
cases75048383cases_
cates75951873cates_
causey113513273causey
caves105639703caves_
cease75227653c_ease
cedes84927323cedes_
cee55952703c_ee__
celery1139623celery
cels65534973c_els_
cense75121403c_ense
cepes94424463cepes_
ceps86125953c_eps_
ceres75540013ceres_
cess65326053c__ess
cetes75731103cetes_
chads116122233chads_
chaeta11310683chaeta
chafes145017913chafes_
chaffy20456473chaffy
chais107530313chais_
chaise114916413chaise
chalky18468773chalky
chally144314293chally
chammy18488953chammy
champy18509613champy
chams126028503chams_
chancy164010863chancy
chanty145215823chanty
chaos105622863chaos_
chapes135421873chapes_
chaps125326063chaps_
chares115631803chares_
charry145012113charry
chars105936633chars_
chary135023133ch_ary
chase105127123ch_ase
chased125019293chased
chaser114918383chaser
chases115128233chases
chasm125518793ch_asm
chasmy16468543chasmy
chasse115114603chasse
chats105730093chats_
chatty14419363chatty
chaws135022463chaws_
chay124924873ch__ay
chays135319743chays_
cheap126915943ch_eap
cheapest1536073cheapest
cheaply1735023cheaply
cheapo134810083cheapo
cheaps134613683cheaps
cheat105732453ch_eat
cheats114519543cheats
chebec1536963chebec
chebecs1635013chebecs
check164714713ch_eck
checks174912703checks
cheder125113493cheder
cheders134512393cheders
cheeked17399663cheeked
cheekily2053473cheekily
cheeped153410593cheeped
cheeper143610743cheeper
cheered133713293cheered
cheerer123511753cheerer
cheerily1655423cheerily
cheerio12379313cheerio
cheeros123711633cheeros
cheesier1335963cheesier
cheesing14349413cheesing
cheetah1545453cheetah
chef125125623ch_e_f
chefed155010563chefed
chegoe1237273chegoe
chegoes1337333chegoes_
chela103916803ch_ela
chelae113614603chelae
chelas113817203chelas
chemic153012093chemic
chemise143211503chemise
chemism16339303chemism
chemist143615003chemist
chemo12313633ch_emo
chemos13311723chemos
cheque2036663cheque
cheques2136863cheques_
cherish15310463cherish
chert105232103ch_ert
cherts115617233cherts
cherub1337263cherub
chesses124112633chesses
chests114916263chests
chetah14399583chetah
cheth135013823ch_eth
cheths14389823cheths
chevies153511443chevies_
chevre14318313chevre
chevres15379793chevres_
chew126622133ch_e_w
chewed154415013chewed
chewer145512613chewer
chewers154111133chewers
chewiest16177293chewiest
chez184519023ch_e_z
chias104625513chias_
chiasm13449103chiasm
chicest14209943chicest
chicly16429203chicly
chics123920943chics_
chides124620473chides_
chief134419473chie_f
chiefest1645313chiefest
chiefly1834103chiefly
chiefs14509653chiefs
chiel104918973chie_l
chield124610213chield
chiels115115933chiels
chiles115425303chiles_
chilly144113223chilly
chimes134922573chimes_
chines115029173chines_
chinky185610543chinky
chins105631463chins_
chippy18437613chippy
chips125721253chips_
chirpy16498913chirpy
chis95933313ch_is_
chisel112111943chisel
chits105424573chits_
chitty14329433chitty
chives144317593chives_
chivvy20374433chivvy
chivy164810363ch_ivy
chokes154917383chokes_
chokey184811713chokey
choky175711223ch_oky
choose115116143choose
choosey15459233choosey
choppy18376293choppy
chops125019873chops_
chores114828023chores_
chose105925403ch_ose
chosen116014133chosen
choses115825123choses
chouse116017563chouse
choush14549063choush
chows135618203chows_
chowse144711753chowse
chrism13710673chrism
christy1536623christy
chromy16309903chromy
chubby1844123chubby
chubs125412623chubs_
chucky20418003chucky
chuffy20445863chuffy
chugs115511943chugs_
chummy18385893chummy
chums125015833chums_
chunky18468273chunky
chutes114615763chutes_
chyles144813283chyles_
chymes165912153chymes_
cicely1338833cicely
cines75239683cines_
cires74932913cires_
cissy104811073c_issy
cites74435583cites_
classy11379043classy
cleek115514913clee_k
cleeks125010543cleeks
clefs106616243clefs_
clepes104214623clepes_
clergy1234993clergy
clerisy1246823clerisy
clews105516333clews_
clues74623033clues_
clumsy13326193clumsy
codes86247293codes_
coeds85920163coeds_
coheres122917693coheres_
cokes115537193cokes_
coles76055063coles_
comedy14378233comedy
comely134213733comely
comes97246993comes_
cones76457423cones_
coney105932883cone_y
coneys115218423coneys
cooees85621893cooees_
cooey105828223cooe_y
cooeys114914483cooeys
copes97747103copes_
cores76361853cores_
coses76949493coses_
cosey106226713cose_y
coseys115215813coseys
cosy97232703c__osy
cotes76347843cotes_
coves105539173coves_
covey136121783cove_y
coveys145413503coveys
coxes145430863coxes_
coyest11316053coyest
cozes166033243cozes_
cozey196718543coze_y
cozeys204610913cozeys
creaky154911553creaky
creamy134811363creamy
crease85519573crease
creds85418773creds_
creed85727393cree_d
creeds94714773creeds
creek114917393cree_k
creeks124812923creeks
creel75121483cree_l
creels84416943creels
creep95218103cree_p
creeps104213623creeps
creeses93914623creeses
cremes104517993cremes_
crepes105419343crepes_
crepey135110933crepey
crepy124812703c_repy
cress75022833c_ress
crest74632693c_rest
cresyl1135133c_resyl
crews105917493crews_
cries75438403cries_
cubes95028163cubes_
cues65438983c_ues_
cukes115422093cukes_
cures75645433cures_
curtesy1265833curtesy
curtsy1156643curtsy
cutely115312803cutely
cutes79438313cutes_
cutest85820143cutest
cutey105819793cute_y
cuteys11569973cuteys
cuvees1139373cuvees_
cyeses11510123cyeses
cymes1210118923cymes_
deedy104315893_deedy
dees56356633_dees_
drees65628523drees_
dressy10518143dressy
dweeby1542993dweeby
easy76224493__easy
eches106322163ech_es_
echoes114715523echoes_
echoey14397853echoe_y
eely77725213__eely
eery76129623__eery
epees75219833epees_
fees76450603_fees_
fleecy14266483fleecy
flees85828753flees_
freely12310953freely
frees86131393frees_
freest95318283freest
geeky134710733_geeky
gees55647883_gees_
geese64316003_geese
geest64829613_geest
ghee85726113ghee__
glees65027593glees_
gleety10479193gleety
greasy10419463greasy
greedy11518843greedy
greeny104811453greeny
grees65132473grees_
haes77651023_haes_
heady125117263_heady
heapy135914983_heapy
heavy144814183_heavy
hebes105521673_hebes_
hedgy134510743_hedgy
heed86437603_hee_d
heeds95420423_heeds
heel75034223_hee_l
heels85625533_heels
heeze175313483_heeze
hefty146112133_hefty
hehs106723963_hehs_
heist87030913_heist
hemes105031083_hemes_
hempy154912763_hempy
hems95534943_hems_
henry114014473_henry
hens75642573_hens_
herby134715313_herby
hereby14468333_hereby
heres86245903_heres_
herry114922473_herry
hers75844873_hers_
hes66654203_h_es_
hest75950773_h_est
hets75547203_hets_
hews105631573_hews_
hexes155123043_hexes_
hey96741063_h_e_y
hies74842833_hies_
hissy116112123_hissy
hoes75755733_hoes_
horsy116318393_horsy
hosey116127023_hosey
hues75235233_hues_
hussy116812763_hussy
jees115938543_jees_
khets124913433khets_
knees95114873knees_
leery85919133_leery
lees45455883_lees_
lichees123512783lichees_
lychees15516783lychees_
messy104913833_messy
needy94614693_needy
newsy11489393_newsy
ochers113915303ochers_
ochery14319443och_ery
ochres113510833ochres_
ogees65119143ogees_
peery105719443_peery
pees65257373_pees_
phoresy1534653phoresy
phrensy1533623phrensy
poesy105014063_poesy
prees75937173prees_
queasy1855173queasy
reedy910020283_reedy
reefy114217703_reefy
reeky125416263_reeky
rees45364193_rees_
reest54938093_reest
rheas84816953rheas_
rhemes115913183rhemes_
rheumy1433353rheumy
schemes1489663schemes_
screes85023963screes_
seedy94821533_seedy
seely84522633_seely
seepy104717973_seepy
sees45361053_sees_
sheas86331793sheas_
sheds96122703sheds_
sheen85023313shee_n
sheeney13398933sheeney
sheens95116993sheens
sheep105321523shee_p
sheer84726893shee_r
sheerly13337703sheerly
sheers94322403sheers
sheet84836953shee_t
sheets93918493sheets
sheeve123412843sheeve
shelly124414463shelly
shelty124011543shelty
shelvy15377863shelvy
sherry124510413sherry
shes75734353sh_es_
shews115924713shews_
shies86136553shies_
shiest95821523shiest
shoes85429653shoes_
shyest125511833shyest
skees95023123skees_
sleeky13398963sleeky
sleepy11479413sleepy
sleety94112653sleety
sneery93610413sneery
sneesh945893sneesh
sneezy18345273sneezy
speedy1218410783speedy
steely93612573steely
sweeny12358843sweeny
sweepy14447453sweepy
teensy9478273teensy
teeny85417883_teeny
tees45353583_tees_
thebes115914493thebes_
thee78039063thee__
theism1139483theism
theist9314763theist
themes115319253themes_
thens85921833thens_
theory121098353theory
thereby1534633thereby
theres96525473theres_
these86519013th_ese
theses96517973theses
thesp105410313th_esp
thews117416193thews_
thewy146311853th_ewy
they107223753th_e_y
threes97117323threes_
thresh12276863thresh
trees55835763trees_
tressy9448553tressy
tweedy13455933tweedy
tweeny12477003tweeny
tyees86019453tyees_
uneasy9278853uneasy
veery115816253_veery
vees75439433_vees_
weedy125115003_weedy
weensy12416823weensy
weeny115316163_weeny
weepy134212593_weepy
wees76249123_wees_
weest85026773_weest
whee105429593whee__
wheel115515333whee_l
wheels123811713wheels
wheen115016053whee_n
wheens124610613wheens
wheep136214353whee_p
wheeps14439953wheeps
wheeze21276813wheeze
whelky19314973whelky
whens114618763whens_
whereby1842913whereby
wheres125917433wheres_
wherry15477333wherry
whets115019613whets_
whews145114493whews_
whey135018713wh_e_y
wheyey1834323wheyey
wheys145911553wheys_
whimsy17375223whimsy
zees136331893_zees_

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.1561145455.1
2DLD Change Limit1127164946.40617595.4
3Display Results4944940.1862655.9
 (SQL Overall)1786914946.74826480.6
 
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.