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

397 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
guesses816937(None) 
guessed9176601guessed
guesser8166541guesser
guessers9174901guessers
blesses93812392blesses
busses85023382bu_sses
cesses84221362_cesses
chesses124112632chesses
cresses94219812cresses
cuisses9319882cuisses
cusses84522772cu_sses
dresses83716172dresses
duresses939172duresses
egresses949442egresses
esses56422972__esses
fesses94820252_fesses
fusses94920552fu_sses
gasses75724782g_asses
gausses8308692gausses
gessoes838292g_essoes
gestes75721392g_estes
glasses84414272glasses
glosses84014122glosses
gneisses933672gneisses
grasses84117342grasses
greases84816712greases
grosses84517682grosses
guess64213362gue_s_s
guested9157712guested
guests74311202gue_sts
guises74216312gu_ises
gurshes112210032gurshes
gushes104719032gu_shes
gusset7316432gu_sset
gussets837442gu_ssets
gussies82813302gussies
jesses135215952_jesses
loesses7310032loesses
messes84924342_messes
musses84624782mu_sses
nesses64718322_nesses
ogresses938472ogresses
oyesses1037332oyesses
presses93523152presses
pusses84322842pu_sses
quasses16209502quasses
susses64221052su_sses
tresses73719542tresses
tusses64921242tu_sses
wusses93314892wu_sses
yesses93615812_yesses
abbesses1235333abbesses
abysses1234863abysses
accesses1287493accesses
aggresses1146143aggresses
amasses93912853amasses
asepses946363asepses
asses55629283__asses
assesses737383assesses
auxeses1435623auxeses
avenses1049643avenses
basses85428303_basses
beses75830723_be_ses
biasses94911653biasses
bignesses1267963bignesses
blessed10319493blessed
blesser9329293blesser
blessers10277633blessers
blisses94911513blisses
bosses85925403_bosses
brasses93818353brasses
brisses94314313brisses
burgesses1245513burgesses
burses84425513bu_rses
buses75936013bu__ses
bushes115226113bu_shes
busies85525263bu_sies
bussed94717053bu_ssed
caresses10314063caresses
ceases84427073_ceases
censes83721803_censes
cessed94615613_cessed
chasses124017503chasses
cheeses123613103cheeses
classes94717943classes
creases94020963creases
creeses93914623creeses
cresset93319943cresset
cressets10309103cressets
crosses94220793crosses
cuestas957933cuestas
cuishes122810823cuishes
cuisse8318333cuisse_
curses85328273cu_rses
cussed94917123cu_ssed
cusser86016093cu_sser
cussers94213403cu_ssers
cussos84210003cu_ssos
cutises94414913cutises
cyeses11510123cye_ses
dieses75218693die_ses
digresses1137863digresses
disses75225963_disses
dosses76126273_dosses
dressed93511873dressed
dresser83611953dresser
dressers9359863dressers
drosses84513823drosses
duchesses1544133duchesses
duendes938193duendes
dueness82310123dueness
duenesses1039333duenesses
dufuses11436593dufuses
dulnesses1037763dulnesses
dulses73913653du_lses
dunnesses1037703dunnesses
eases56041613__eases
ecesises1037023ecesises
egressed1046873egressed
emeses86114963eme_ses
erses55826803__erses
eses45336103__e_ses
esnes54817363__esnes
excesses1736753excesses
eyasses10388023eyasses
feases95422923_feases
fesse86116333_fesse_
fessed104515063_fessed
finesses111912343finesses
flenses1039473flenses
fleshes133913273fleshes
flosses103411973flosses
fosses96022083_fosses
frasses104314513frasses
freshes133515823freshes
fucoses12148303fucoses
fucuses12158353fucuses
fulnesses1239053fulnesses
fusees95416403fu_sees
fuses85628423fu__ses
fussed104613803fu_ssed
fusser94813773fu_sser
fussers104210813fu_ssers
gases65633993g__ases
gashes105725153g_ashes
gassed85217633g_assed
gasser75017773g_asser
gassers84714633g_assers
gaynesses1336563gaynesses
gees55647883g_e__es
geese64316003g_eese_
geests75912163g_eests
gelees74116263g_elees
genes65133093g_e_nes
geneses82613523geneses
genies75324943g_enies
genres75515623g_enres
gentes75324163g_entes
genuses83510883genuses
geodes8412153g_eodes
gesso649603g_ess_o
gessoed935743g_essoed
geste65920693g_este_
gests66028813g_e_sts
geyser1036513g_eyser
geysers1135703g_eysers
ghees95215553ghe__es
gipsies1039903gipsies
girshes11248293girshes
glassed93710433glassed
glassies94012273glassies
glebes95512243gle_bes
gledes84915133gle_des
glees65027593gle__es
glossas8438193glossas
glossed94410073glossed
glosser83410813glosser
glossers9319053glossers
glossies93311253glossies
glucoses1145333glucoses
gluinesses1138233gluinesses
glumnesses1344733glumnesses
gnashes11419573gnashes
gneiss765953gneis_s
gnoses76515163g_noses
goddesses1243453goddesses
gooses75723053g_ooses
gorses74723293g_orses
grassed93812793grassed
grease75416233grease_
greased93812393greased
greaser83913083greaser
greasers93410253greasers
greaves113311443greaves
grebes93813613gre_bes
grees65132473gre__es
greiges937733greiges
greisen856503greisen
greisens954653greisens
grilses8319153grilses
grossed93812253grossed
grosser84313143grosser
grossers94410973grossers
grossest93810093grossest
grouses84616543grouses
guanases936233guanases
gudes74520813gu__des
guenons836563guenons
guernsey1281483guernsey
guernseys1381033guernseys
guessing1036243guessing
guest65225923gue_s_t
guggles103410543guggles
guides84118283gu_ides
guiles73919283gu_iles
guimpes1245073guimpes
guise64717713gu_ise_
guised84612173gu_ised
gulches13398103gulches
gules64831043gu__les
gullies84717313gullies
gumless10228273gumless
gummoses1344743gummoses
gumshoes1444123gumshoes
gunites8313123gunites
gunless8299633gunless
gunnies83413123gunnies
gunsel7339853gu_nsel
gunsels8338133gunsels
guppies123310523guppies
gurges84716863gu_rges
gurgles94312873gurgles
gurries83515953gurries
gushed114816243gu_shed
gusher104115773gu_sher
gushers113512513gu_shers
gussie72910153gu_ssie
gussied9267193gussied
gussy95314323gu_ss_y
gusted84316723gu_sted
gustoes879873gustoes
gusts65722793gu__sts
gutless82610713gutless
gutsier8389823gutsier
gutsiest92610583gutsiest
guttles83011933guttles
guzzles16328043guzzles
gypsies1335953gypsies
gyrases11368313gyrases
hisses94719353_hisses
hueless1058823hueless
humuses1237593humuses
hushes124718593hu_shes
hussies103213293hussies
idlesses936003idlesses
ileuses738673ileuses
ingresses1038533ingresses
jesse126012833_jesse_
jessed144112303_jessed
josses135117683_josses
judases1534443judases
kisses104217333_kisses
knesset11310413knesset
knessets1243173knessets
kumisses1443583kumisses
kumyses1633143kumyses
kussos10336423ku_ssos
kvasses14365503kvasses
lasses64827593_lasses
leases65428113_leases
lenses64620893_lenses
leses54930813_le_ses
lessee64116363_lessee
lessees73510243_lessees
lessen64212433_lessen
lessens7409383_lessens
lesser63514853_lesser
losses65925233_losses
lupuses936273lupuses
lushes94022743lu_shes
lususes736713lususes
masses85028713_masses
menses84222453_menses
meshes115019443_meshes
mesnes85216213_mesnes
messed95018183_messed
misguesses1343323misguesses
misses85130873_misses
mosses85527683_mosses
mousses94012703mousses
mucuses11148513mucuses
mueslis935493mueslis
muses75134303mu__ses
mushes114124563mu_shes
mussed94418903mu_ssed
mussel83412903mu_ssel
mussels9419843mu_ssels
mutases92012043mutases
noesises838503noesises
nurses63919353nu_rses
obsesses1036223obsesses
outguesses1143613outguesses
outsees72616433outsees
passes86030473_passes
peases85229473_peases
peises84125043_peises
perses85428063_perses
pisses84525083_pisses
pleases94515483pleases
plisses94411773plisses
plusses93510693plusses
poesies93217403poesies
posses85128803_posses
pressed103317313pressed
presser93717623presser
pressers103215023pressers
prisses94816713prisses
prosses94019513prosses
puisnes937423puisnes
pulses83818663pu_lses
purses84826373pu_rses
pursues94111373pursues
puses75532203pu__ses
pushes114621663pu_shes
pussies93615693pussies
quashes192110973quashes
queries16315873queries
quested17168383quested
quester161410023quester
questers17168763questers
quests153310353que_sts
queues153510193que_ues
qurshes19228573qurshes
recesses10312323recesses
regresses10310463regresses
resees63827483_resees
reshes94124363_reshes
reuses66025523_reuses
rhesuses1134893rhesuses
rubasses1035493rubasses
ruses56136583ru__ses
rushes94724363ru_shes
russet6319433ru_sset
russets738163ru_ssets
sasses64124393_sasses
seises64026713_seises
senses63923943_senses
sepses84515883_sepses
sisses64520603_sisses
speises93813933speises
speisses10245693speisses
spenses92913573spenses
stresses81112493stresses
successes1345643successes
sudses74114503su_dses
suedes73918113sue_des
sussed75015533su_ssed
swisses10417143swisses
tasses64826763_tasses
teases65426273_teases
tenses64722553_tenses
testes65125823_testes
theses96517973the_ses
tigresses1046403tigresses
tmeses85712243tme_ses
tosses65225393_tosses
trasses74819323trasses
tressed83714263tressed
tressel73010893tressel
tressels8367653tressels
trusses73813643trusses
tsetses785453tsetses
tumesces1244843tumesces
tushes94319473tu_shes
tusseh9448423tu_sseh
tussehs10395563tu_ssehs
tusser64615833tu_sser
tussers74313563tu_ssers
tussis6379953tu_ssis
tussises835433tussises
tussles737833tussles
ukases10358063_ukases
uneases73316263uneases
upases84112903_upases
urases63723563_urases
ureases74416723ureases
uruses63616503_uruses
uses44931113_u__ses
verses94223763_verses
vessel937953_vessel
vessels1035933_vessels
vitesses1136333vitesses
wisses94619603_wisses
wrasses103812593wrasses
wussies103411083wussies
yeses85119323_ye_ses
yessed104511163_yessed

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 Filter1786911340270.410435831.7
2DLD Change Limit1340273975.98322401.3
3Display Results3973970.1402835.7
 (SQL Overall)1786913976.53327352.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.