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

286 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
guesser816654(None) 
guessed9176601guessed
guessers9174901guessers
guesses8169371guesses
blesser9329292blesser
cusser86016092cu_sser
dresser83611952dresser
fusser94813772fu_sser
gasser75017772g_asser
geyser1036512g_eyser
glosser83410812glosser
greaser83913082greaser
grosser84313142grosser
guess64213362guess__
guested9157712guested
gusher104115772gu_sher
gusset7316432gu_sset
gutsier8389822gutsier
lesser63514852_lesser
presser93717622presser
quester161410022quester
tusser64615832tu_sser
amasser9418733amasser
blessed10319493blessed
blessers10277633blessers
blesses93812393blesses
bluesier1034943bluesier
burster9310293burster
busher114922203bu_sher
busier85219723bu_sier
busker125517833bu_sker
bussed94717053bu_ssed
busses85023383bu_sses
buster84726493bu_ster
caresser1038813caresser
censer84516583_censer
cessed94615613_cessed
cesses84221363_cesses
chesses124112633chesses
classer93614613classer
crasser94114343crasser
creaser94415743creaser
cresses94219813cresses
cresset93319943cresset
crosser95015463crosser
cuisse8318333cuisse_
cuisses9319883cuisses
curser84721473cu_rser
cussed94917123cu_ssed
cussers94213403cu_ssers
cusses84522773cu_sses
cutesier1045623cutesier
denser74115193_denser
dessert82916453_dessert
diester83013683diester
dosser74417973_dosser
dressed93511873dressed
dressers9359863dressers
dresses83716173dresses
dressier956863dressier
dueler74213683due_ler
dueller8329833dueller
duresses939173duresses
duster74919723du_ster
egressed1046873egressed
egresses949443egresses
esker94412983__esker
esses56422973__esses
ester54727713__ester
fesse86116333_fesse_
fessed104515063_fessed
fesses94820253_fesses
fester94723513_fester
flenser1036783flenser
flesher133610923flesher
flosser10339693flosser
fresher132612643fresher
fubsier12367763fubsier
fuehrer1332973fuehrer
fueler94313933fue_ler
fueller10279963fueller
fussed104613803fu_ssed
fussers104210813fu_ssers
fusses94920553fu_sses
fussier103610673fussier
gagster9317633gagster
gamester1137323gamester
gasher104320373g_asher
gasper94515543g_asper
gassed85217633g_assed
gassers84714633g_assers
gasses75724783g_asses
gassier83812573gassier
gaster75027353g_aster
gausses8308693gausses
geekier12286393geekier
geese64316003g_eese_
geezer16278013g_eezer
gelder84613713g_elder
gender83517933g_ender
gesso649603g_ess_o
gessoed935743g_essoed
gessoes838293g_essoes
geste65920693g_este_
gestes75721393g_estes
getter74117613g_etter
geysers1135703g_eysers
glassed93710433glassed
glasses84414273glasses
glassier9289083glassier
gleamer10328513gleamer
gleaner8379773gleaner
glister84013343glister
glossed94410073glossed
glossers9319053glossers
glosses84014123glosses
glossier9358203glossier
gneisses933673gneisses
goosier83512563goosier
gorsier83811073gorsier
grasper10389793grasper
grassed93812793grassed
grasses84117343grasses
grassier9349283grassier
grease75416233grease_
greased93812393greased
greasers93410253greasers
greases84816713greases
greasier9298083greasier
greater84416493greater
greener83111713greener
greeter82812673greeter
greisen856503greisen
greyer104510093gre_yer
grister83915413grister
grossed93812253grossed
grossers94410973grossers
grosses84517683grosses
grouser84513693grouser
grueler837023grue_ler
grueller935333grueller
gruesomer1243003gruesomer
guarder936463guarder
guernsey1281483guernsey
guessing1036243guessing
guesswork1752063guesswork
guest65225923gue_s_t
guests74311203gue_sts
guider84313523gu_ider
guilder945913guilder
guise64717713gu_ise_
guised84612173gu_ised
guises74216313gu_ises
gulfier1137793gulfier
gulper93410213gu_lper
gulpier1046953gulpier
gummer114615453gu_mmer
gummier12349473gummier
gunkier12369553gunkier
gunner73813983gu_nner
gunsel7339853gu_nsel
gurshes112210033gurshes
gushed114816243gu_shed
gushers113512513gu_shers
gushes104719033gu_shes
gushier113110073gushier
gussets837443gu_ssets
gussie72910153gu_ssie
gussied9267193gussied
gussies82813303gussies
gussy95314323gu_ss_y
gusted84316723gu_sted
gustier83813863gustier
gutter73817713gu_tter
guttier83911103guttier
guttler8369163guttler
guzzler16286563guzzler
gypster1333953gypster
hisser94713793_hisser
husker134212703hu_sker
hussar9317283hu_ssar
jesse126012833_jesse_
jessed144112303_jessed
jesses135215953_jesses
jester134319153_jester
juster134617013ju_ster
keester11319913keester
kiester11329973kiester
kisser104212453_kisser
knesset11310413knesset
leaser65322673_leaser
lessee64116363_lessee
lessen64212433_lessen
lessor64010603_lessor
loesses7310033loesses
lusher93818763lu_sher
luster64023673lu_ster
messed95018183_messed
messes84924343_messes
messier93412923_messier
mosser84618273_mosser
muenster1043313muenster
munster93710523munster
muser76024123mu__ser
musher113820573mu_sher
mussed94418903mu_ssed
mussel83412903mu_ssel
musses84624783mu_sses
mussier93314363mussier
muster84724523mu_ster
nesses64718323_nesses
nester64124183_nester
nurser64314503nu_rser
nutsier7329253nutsier
ogresses938473ogresses
ouster64223733ou_ster
oyesses1037333oyesses
passer84721033_passer
pester84827593_pester
pisser84416383_pisser
pleaser93912343pleaser
plessor9317693plessor
pressed103317313pressed
pressers103215023pressers
presses93523153presses
pressor93512883pressor
prester93519623prester
pulser84215193pu_lser
punster92911103punster
purser85020473pu_rser
pursier94012753pursier
pursuer9338893pursuer
pusher114318283pu_sher
pusses84322843pu_sses
pussier93711993pussier
quasher19198623quasher
quasses16209503quasses
queasier1734473queasier
queer143712813que__er
queerer16106503queerer
queller16289293queller
querier16310013querier
quested17168383quested
questers17168763questers
questor16146633questor
queuer15357253que_uer
rester63832433_rester
rusher94019653ru_sher
russet6319433ru_sset
seiser65318343_seiser
sudser73511283su_dser
sudsier868783sudsier
sussed75015533su_ssed
susses64221053su_sses
teaser65421523_teaser
tenser64919433_tenser
terser67317823_terser
tessera736333_tessera
tester64227153_tester
tosser64215663_tosser
tressed83714263tressed
tressel73010893tressel
tresses73719543tresses
tressier847963tressier
trusser74010263trusser
tusker104212193tu_sker
tussar6369543tu_ssar
tusseh9448423tu_sseh
tussers74313563tu_ssers
tusses64921243tu_sses
tussor6378233tu_ssor
tussur6357293tu_ssur
ulster63712103_ulster
user45023003_u__ser
usher84517763_u_sher
verser94516963_verser
vesper1138083_vesper
vessel937953_vessel
wester94222893_wester
wrester102812413wrester
wusses93314893wu_sses
wussier10408083wussier
yessed104511163_yessed
yesses93615813_yesses
yester93417983_yester
zester153617793_zester

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 Limit1340272866.51620568.9
3Display Results2862860.1102600.0
 (SQL Overall)1786912867.03225411.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.