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

326 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
gessoes83829(None) 
gessoed935741gessoed
cesses84221362cess_es
esses56422972_ess_es
fesses94820252fess_es
gasses75724782gass_es
geckoes14325792geckoes
gesso649602gesso__
gestes75721392ge_stes
guesses8169372guess_es
gussies82813302gussies
gustoes879872gustoes
jesses135215952jess_es
lassoes74613852lassoes
lessees73510242lessees
lessons73811012lessons
lessors73610522lessors
messes84924342mess_es
nesses64718322ness_es
reshoes102316032reshoes
yesses93615812yess_es
asses55629283_ass_es
basses85428303bass_es
bassos85313703basso_s
bedsores1157633bedsores
beses75830723be_s_es
besides104814533besides
besmokes16406363besmokes
besnows1245153besnows
besoms105712733be_soms
besots86415453be_sots
bestows1248863bestows
blesses93812393bless_es
bosses85925403boss_es
bossies94116833bossies
busses85023383buss_es
ceases84427073ceas_es
censes83721803cens_es
censors93611833censors
cessed94615613cess_ed
cessions1039853cessions
cestodes1138203cestodes
cestos84718093cesto_s
chesses124112633chess_es
ciscoes113610733ciscoes
cissies94116153cissies
cresses94219813cress_es
cusses84522773cuss_es
cussos84210003cusso_s
dassies84418663dassies
deashes113313903deashes
demoses103815823demoses
deposes103117213deposes
desexes1537833desexes
desires81316133desires
despots10319683despots
disses75225963diss_es
dosses76126273doss_es
dresses83716173dress_es
eases56041613_eas_es
easies64126633_easies
echoes114715523_echoes
eddoes8199143_eddoes
egises7312493egis_es
egresses949443egress_es
ensues63313813_ensues
eposes84418783_eposes
eroses65327053_eroses
erses55826803_ers_es
escots84211743_escots
eses45336103_e_s_es
esnes54817363_e_snes
espies83716803_espies
essays965653_essays
essoin638193_essoin
essoins737603_essoins
estops84011223_estops
fatsoes10379423fatsoes
feases95422923feas_es
felloes104114383felloes
fescues1236783fescues
fesse86116333fess_e_
fessed104515063fess_ed
fosses96022083foss_es
frescoes1357833frescoes
fusses94920553fuss_es
gascons10289103gascons
gaseous839503gaseous
gases65633993g_as_es
gashes105725153g_ashes
gassed85217633gass_ed
gasser75017773gass_er
gassers84714633gassers
gassier83812573gassier
gassiest93212523gassiest
gausses8308693gausses
geckos13457433gecko_s
gees55647883ge___es
geese64316003gees_e_
geests75912163gees_ts
geishas1135073geishas
gelates83219583gelates
gelees74116263ge_lees
gemotes103712143gemotes
gemots93712153ge_mots
gemsboks1742013gemsboks
gemstones1245563gemstones
genes65133093ge__nes
geneses82613523geneses
genies75324943ge_nies
genoas74013623ge_noas
genomes103611703genomes
genoms94412483ge_noms
genres75515623ge_nres
genros74211333genro_s
gentes75324163ge_ntes
gentles83714343gentles
gentoos838633gentoos
genuses83510883genuses
geodes8412153ge_odes
gestates93213733gestates
geste65920693ge_ste_
gests66028813ge_s_ts
gestures9310013gestures
geyser1036513geys_er
geysers1135703geysers
gheraoes1244813gheraoes
ghettoes1243493ghettoes
gibsons1045043gibsons
ginzoes1735433ginzoes
gipsies1039903gipsies
girshes11248293girshes
gismos957183gismo_s
glasses84414273glasses
glassies94012273glassies
glosses84014123glosses
glossies93311253glossies
gnashes11419573gnashes
gneisses933673gneisses
gneissose1051173gneissose
gnoses76515163gnos_es
goboes95914443g_oboes
godsons966663godsons
goes55644093g___oes
gooses75723053goos_es
gorses74723293gors_es
gossans836783gossans
gossips1035903gossips
gossoon865663gossoon
gossoons944893gossoons
grasses84117343grasses
greases84816713greas_es
grisons838993grisons
grosses84517683grosses
guessed9176603guess_ed
guesser8166543guess_er
guessers9174903guessers
guises74216313guis_es
gumshoes1444123gumshoes
gurshes112210033gurshes
gushes104719033g_ushes
gusset7316433guss_et
gussets837443gussets
gussie72910153gussie_
gussied9267193gussied
gypsies1335953gypsies
hassles103411693hassles
helloes103717463helloes
heroes94923823he_roes
hessites1138613hessites
hexoses17228883hexoses
hisses94719353hiss_es
hissies103915823hissies
hussies103213293hussies
hyssops1543123hyssops
issues648803_issues
jesse126012833jess_e_
jessed144112303jess_ed
jetsoms16124723jetsoms
josses135117683joss_es
kelsons1137323kelsons
ketoses114912873ketoses
kisses104217333kiss_es
kussos10336423kusso_s
lasses64827593lass_es
lassies74420103lassies
lassoed8408743lassoed
lassoer7379383lassoer
lassoers8338513lassoers
lassos64913813lasso_s
leases65428113leas_es
leashes103514403leashes
lenses64620893lens_es
lesbos837403lesbo_s
leses54930813le_s_es
lesions73813863lesions
lessee64116363less_ee
lessen64212433less_en
lessens7409383lessens
lesser63514853less_er
lesson64412043lesso_n
lessoned945393lessoned
lessor64010603lesso_r
loesses7310033loess_es
losses65925233loss_es
masses85028713mass_es
measles92412753measles
meioses9310833meioses
menses84222453mens_es
menshes12310443menshes
meshes115019443me_shes
mesnes85216213me_snes
mesons83215843me_sons
mesosomes1345763mesosomes
messages1138233messages
messans92710463messans
messed95018183mess_ed
messier93412923messier
messiest103112423messiest
messmen1137393messmen
mestees94617753mestees
mestesoes1145323mestesoes
misdoes10312493misdoes
misses85130873miss_es
missies93423983missies
mosses85527683moss_es
musses84624783muss_es
nelsons738003nelsons
nestles73015463nestles
nestors73614973nestors
newsies101310383newsies
ogresses938473ogress_es
oyesses1037333oyess_es
passes86030473pass_es
peases85229473peas_es
peises84125043peis_es
pekoes124410423pe_koes
pensees9311203pensees
perses85428063pers_es
persons93717013persons
pesades10310903pesades
pesos77221623pe_so_s
pestles93217693pestles
pestos84719083pesto_s
pisses84525083piss_es
plessors10278253plessors
posses85128803poss_es
presses93523153press_es
pressors103212683pressors
pusses84322843puss_es
pussies93615693pussies
rassles73513923rassles
reasons72514943reasons
redoes74623753re_does
reissues845993reissues
reposes94021263reposes
resales74724903resales
rescores105415693rescores
rescues9312753rescues
resees63827483re_sees
reshes94124363re_shes
reshoe92816483reshoe_
reshoed112212153reshoed
reshows132510453reshows
resides84523283resides
resiles74026543resiles
resites74027793resites
resizes164216843resizes
resods74116303re_sods
resoles73823653resoles
resows93915353re_sows
respots92912763respots
restokes125213043restokes
restores85222993restores
resumes9313373resumes
reuses66025523reus_es
rissoles839113rissoles
roscoes9310923roscoes
sasses64124393sass_es
sassies74719263sassies
seasons72614233seasons
seises64026713seis_es
seisors73212833seisors
senses63923943sens_es
sensors73514633sensors
sepses84515883seps_es
sesames9310743sesames
sessions839723sessions
shoes85429663__shoes
sisses64520603siss_es
sissies73716603sissies
sloes54728873__sloes
susses64221053suss_es
tasses64826763tass_es
tassies74918933tassies
teases65426273teas_es
telsons739213telsons
tenses64722553tens_es
tensors72712373tensors
testees74215913testees
testes65125823te_stes
testons7313553testons
tissues737463tissues
toeshoes1147713toeshoes
tosses65225393toss_es
tresses73719543tress_es
tusses64921243tuss_es
tussles737833tussles
tussores8316533tussores
tussors7388773tussors
verses94223763vers_es
versos93812803verso_s
verstes104014283verstes
vessel937953vess_el
vessels1035933vessels
vestees103513173vestees
vetoes92914083ve_toes
weasons102310583weasons
welshes13379093welshes
wisses94619603wiss_es
wusses93314893wuss_es
wussies103411083wussies
xeroses143612823xeroses
yeses85119323ye_s_es
yessed104511163yess_ed
zeroes154314343ze_roes

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.1561145455.1
2DLD Change Limit1340273266.31321230.3
3Display Results3263260.1102963.6
 (SQL Overall)1786913266.57927160.8
 
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.