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

459 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
cheeses12361310(None) 
cheese113812761cheese_
cheesed133910681cheesed
chesses124112631chesses
creeses93914621creeses
ceases84427072c_eases
censes83721802c_enses
cesses84221362c_esses
chaises124317492chaises
chaoses124715122chaoses
chases115128232ch_ases
chasses124017502chasses
cheeked17399662cheeked
cheeks154712782chee_ks
cheeped153410592cheeped
cheeper143610742cheeper
cheepers15329012cheepers
cheeps135312912chee_ps
cheered133713292cheered
cheerer123511752cheerer
cheerers13319542cheerers
cheeros123711632cheeros
cheers114518912chee_rs
cheesier1335962cheesier
cheesiest1436322cheesiest
cheesy14419192chees_y
chegoes1337332chegoes
chemises153211982chemises
cheques2136862cheques
chess105016922ch_es_s
chests114916262ch_ests
chevies153511442chevies
chevres15379792chevres
chooses125717422chooses
choses115825132ch_oses
chouses125117812chouses
chowses155611282chowses
creases94020962creases
creese84014332creese_
creeshes1336952creeshes
cresses94219812cresses
cyeses11510122c_yeses
heezes184211642_heezes
phereses1348092phereses
sheeves133911952sheeves
theses96517972th_eses
wheezes22306802wheezes
accesses1287493accesses
achenes12313493ach_enes
achieves1645523achieves
ageneses939303ageneses
aphereses1466423aphereses
apheses12610703apheses
asceses938623asceses
asepses946363asepses
askeses1136463askeses
auxeses1435623auxeses
avenses1049643avenses
beeves114615043_beeves
behests1235953behests
beses75830723__beses
bheesties1443923bheesties
bheesty1542493bheesty
blesses93812393blesses
breezes18318693breezes
calesas9411833calesas
camases114216343camases
camises114218463camises
caress85720263cares_s
caresses10314063caresses
carses85233653c_arses
caseases10410473caseases
caseoses1039293caseoses
cases75048383c__ases
causes88026473c_auses
cayuses12188403cayuses
cease75227653c_ease_
ceased94920783c_eased
cedes84927333c__edes
cees65941593c__e_es
celestes10310013celestes
cense75121403c_ense_
censed94016323c_ensed
censer84516583c_enser
censers94313903c_ensers
census84310303c_ensus
centeses1079443centeses
cepes94424463c__epes
ceres75540013c__eres
cereuses1049243cereuses
cerises94722253cerises
certes84623083c_ertes
ceruses93716233ceruses
cess65326053c__es_s
cessed94615613c_essed
cetes75731103c__etes
chafes145017913ch_afes
chaines124518733chaines
chaise114916413chaise_
chamises153513313chamises
chances145218093chances
changes134517583changes
chapes135421873ch_apes
charases131312763charases
chares115631803ch_ares
charges134615983charges
chase105127123ch_ase_
chased125019293ch_ased
chaser114918383ch_aser
chasers123714923chasers
chasms135513143ch_asms
chasse115114603chasse_
chassed134712133chassed
chassis123910663chassis
chausses1345963chausses
cheapen14407623cheapen
cheapens15305943cheapens
cheaper144010583cheaper
cheapest1536073cheapest
cheapies1539033cheapies
cheapos14418513cheapos
cheaps134613683ch_eaps
cheated134416343cheated
cheater124816963cheater
cheaters133613513cheaters
cheats114519543ch_eats
chebec1536963ch_ebec
chebecs1635013chebecs
checked193710023checked
checker18329533checker
checkers19317843checkers
checks174912703ch_ecks
cheder125113493ch_eder
cheders134512393cheders
chedites1438263chedites
cheek145115713ch_e_ek
cheekier1735103cheekier
cheekiest1835703cheekiest
cheekless1873883cheekless
cheeky18448613chee_ky
cheep125416503ch_e_ep
cheer105420383ch_e_er
cheerier1348003cheerier
cheeriest1438213cheeriest
cheerio12379313cheerio
cheerios13317583cheerios
cheerled14105703cheerled
cheerless1495293cheerless
cheerly15417603cheerly
cheero114712933chee_ro
cheery144913153chee_ry
cheesily1654413cheesily
cheesiness1544733cheesiness
cheesing14349413cheesing
cheetah1545453cheetah
cheetahs1643783cheetahs
chefed155010563ch_efed
cheffed19335863cheffed
chefs136214663ch_e_fs
chegoe1237273chegoe_
chelae113614603chelae_
chelas113817203ch_elas
chelates132713843chelates
chemics16349583chemics
chemise143211503chemise_
chemisms17278213chemisms
chemists152710323chemists
chemos13311723ch_emos
cheque2036663cheque_
chequer2135153chequer
chequers2234103chequers
cherishes1767563cherishes
cherries131812983cherries
cherts115617233ch_erts
cherubs1434553cherubs
chessmen1544463chessmen
chest104926143ch_es_t
chested133811673chested
chesty144610503ch_esty
chetahs15347073chetahs
cheths14389823ch_eths
chevied16357483chevied
chevre14318313chevre_
chevret153310633chevret
chevrets16255323chevrets
chewed154415013ch_ewed
chewer145512623ch_ewer
chewers154111143chewers
chewier1537593chewier
chewiest16177293chewiest
chews135418513ch_e_ws
chiasms14357523chiasms
chiauses1336483chiauses
chicles143512503chicles
chides124620473ch_ides
chiefer1536863chiefer
chiefest1645313chiefest
chiefs14509653chie_fs
chields13507483chields
chiels115115933chie_ls
chigoes1338353chigoes
childes134211273childes
chiles115425303ch_iles
chilies124218303chilies
chimeres153511313chimeres
chimes134922573ch_imes
chines115029173ch_ines
chintses1337113chintses
chirres123812253chirres
chisel112111943ch_isel
chisels12219103chisels
chives144317593ch_ives
chivies153412853chivies
choices142010613choices
chokes154917383ch_okes
choose115116143choose_
chooser124412973chooser
choosers134810873choosers
choosey15459233choosey
chores114828023ch_ores
choruses1339983choruses
chose105925403ch_ose_
chosen116014133ch_osen
chouse116017563chouse_
choused135012463choused
chouser125212943chouser
chousers134610203chousers
choushes1637623choushes
chowse144711753chowse_
chowsed16478613chowsed
chrisms1499143chrisms
chromes142914933chromes
chutes114615773ch_utes
chyles144813283ch_yles
chymes165912153ch_ymes
classes94717943classes
clauses93813323clauses
cleanses10358143cleanses
cleaves124111623cleaves
cleeked14357733cleeked
cleeks125010543clee_ks
cleomes1138813cleomes
clepes104214623c_lepes
clevises1336903clevises
closes85425593c_loses
coerces11311943coerces
coheres122917693coheres
coleuses1039723coleuses
cooees85621893cooe_es
copses104922473c_opses
corpses113913803corpses
corses84433463c_orses
coses76949493c__oses
courses94218893courses
crases85532313c_rases
crease85519573crease_
creased104315583creased
creaser94415743creaser
creasers103612843creasers
creates95225203creates
creches14313093creches
creeds94714773cree_ds
creeks124812923cree_ks
creeled104012013creeled
creels84416943cree_ls
creeped12329713creeped
creeper11339983creeper
creepers12318633creepers
creepies1239613creepies
creeps104213623cree_ps
creesh11328333crees_h
creeshed1435693creeshed
cremes104517993c_remes
creoles9913323creoles
crepes105419343c_repes
cress75022833c_res_s
cresset93319943cresset
cressets10309103cressets
crests85218703c_rests
crises84529433c_rises
crosses94220793crosses
cruises93514443cruises
cruses88127713c_ruses
cuisses9319883cuisses
culexes1636993culexes
curses85328273c_urses
cusses84522773c_usses
cutises94414913cutises
cuvees1139373cuve_es
cycases1437533cycases
cyesis1148573c_yesis
cymenes1477413cymenes
cypreses1535143cypreses
diereses938693diereses
dieses75218693_dieses
dresses83716173dresses
duchesses1544133duchesses
eases56041613__eases
echelles1346673echelles
emeses86114963_emeses
erses55826803__erses
eses45336103___eses
esses56422973__esses
exegeses1644213exegeses
feases95422923_feases
feezes184412613_feezes
fesses94820253_fesses
fleeces12399643fleeces
flenses1039473flenses
freezes193310353freezes
geese64316003_geese_
geests75912163_geests
geneses82613523geneses
ghees95215553gh_e_es
greases84816713greases
guesses8169373guesses
haeres94017033_haeres
hanses95022633_hanses
hawses125113993_hawses
hearses104414533_hearses
heaves124120303_heaves
hebes105521673_h_ebes
hedges115016263_hedges
heeded114215763_heeded
heeder104216043_heeder
heeders114213743_heeders
heeds95420423_hee_ds
heeled104018413_heeled
heeler93917313_heeler
heelers103815623_heelers
heels85625533_hee_ls
heeze175313483_heeze_
heezed194210513_heezed
heists96814633_heists
helves124316063_helves
hemes105031083_h_emes
henges104516463_henges
heredes11313133_heredes
heres86245903_h_eres
heresies11312693_heresies
heroes94923823_heroes
herpes115517323_herpes
hests85829933_h_ests
hexes155123043_h_exes
hexoses17228883_hexoses
hisses94719353_hisses
hoises94823673_hoises
horses94729343_horses
hoses85443173_h_oses
houses96032273_houses
ileuses738673ileuses
jesses135215953_jesses
joneses1438963joneses
keeves133711993_keeves
kineses113111253kineses
kneesies1245543kneesies
leases65428113_leases
lenses64620893_lenses
leses54930813__leses
loesses7310033loesses
menses84222453_menses
messes84924343_messes
mimeses1139073mimeses
nemeses948663nemeses
nesses64718323_nesses
oyesses1037333oyesses
pareses94718883pareses
peases85229473_peases
peeves113814873_peeves
peises84125043_peises
perses85428063_perses
phases114618403ph_ases
pheresis1377633pheresis
phoebes1435813phoebes
phrases12711463phrases
phyleses1645183phyleses
physes14399783ph_yses
pleases94515483pleases
presses93523153presses
reests64618893_reests
reeves94721493_reeves
resees63827483_resees
reuses66025523_reuses
rhemes115913183rh_emes
rhesus936203rh_esus
rhesuses1134893rhesuses
rhuses94911793rh_uses
schemes1489663sch_emes
schusses1334213schusses
seises64026713_seises
senses63923943_senses
sepses84515883_sepses
sheaves134412973sheaves
sheened113511703sheened
sheeney13398933sheeney
sheeneys14294903sheeneys
sheenies111411543sheenies
sheens95116993shee_ns
sheered113515453sheered
sheerer103813843sheerer
sheerest11310083sheerest
sheers94322403shee_rs
sheesh1237813shees_h
sheeted113813043sheeted
sheeter103814913sheeter
sheeters113111863sheeters
sheets93918503shee_ts
sheeve123412843sheeve_
shelves134112093shelves
shikses14116573shikses
sleeves103311343sleeves
sneeshes1136513sneeshes
sneezes16278503sneezes
speises93813933speises
spenses92913573spenses
steeves103410903steeves
teases65426273_teases
teleses7313123teleses
tenses64722553_tenses
thebes115914493th_ebes
theines104013233theines
theisms1237763theisms
theists1039153theists
themes115319253th_emes
theres96525473th_eres
thermes126214613thermes
these86519013th_ese_
thesis94913733th_esis
thesps11448263th_esps
thieves1346903thieves
threes97117323thre_es
threshes1437383threshes
thyrses1335023thyrses
tmeses85712243_tmeses
tresses73719543tresses
tsetses785453tsetses
tweezes19345703tweezes
uneases73316263uneases
ureases74416723ureases
verses94223763_verses
wheedles1534643wheedles
wheeled14318463wheeled
wheeler13298773wheeler
wheelers14287733wheelers
wheelies1437863wheelies
wheels123811713whee_ls
wheens124610613whee_ns
wheeped16387503wheeped
wheeples1634743wheeples
wheeps14439953whee_ps
wheeze21276813wheeze_
wheezed23296453wheezed
wheezer22296673wheezer
wheezers23265273wheezers
whereases1545673whereases
wheres125917433wh_eres
wherves16548053wherves
yeses85119323__yeses
yesses93615813_yesses

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 Limit1340274596.59320328.7
3Display Results4594590.1732653.2
 (SQL Overall)1786914597.17224915.1
 
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.