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

373 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
guesting105846(None) 
guessing1036241guessing
gusting93917161gu_sting
questing1838271questing
besting104923922_besting
bursting1138702bursting
busting104221792bu_sting
cresting114017042cresting
dueting93814392due_ting
duetting1047182duetting
dusting93618992du_sting
egesting1039012egesting
gasting95022762g_asting
getting93316562g_etting
ghosting1336462ghosting
gleeting10279172gleeting
greeting103112352greeting
guising93511412guis_ing
gushing124014222gu_shing
gusseting1173962gusseting
gussying1334062gussying
gutting93415922gu_tting
jesting154317712_jesting
justing153615162ju_sting
lusting83619322lu_sting
musting103221072mu_sting
nesting84320442_nesting
ousting84021352ou_sting
reesting93118272reesting
resting85031182_resting
rusting83821262ru_sting
testing86021052_testing
vesting114618682_vesting
westing115020272_westing
wresting123811832wresting
zesting174515332_zesting
abetting1158293abetting
agenting1039383agenting
agisting1038243agisting
alerting91312383alerting
arresting1038633arresting
attesting1036383attesting
auditing1039033auditing
averting122512733averting
basting104227203_basting
beating104326873_beating
beestings12335923beestings
beeswing14255763beeswing
belting104119133_belting
betting103921403_betting
biestings12266033biestings
blasting114013433blasting
bleating113514503bleating
blessing1137593blessing
boasting113512503boasting
boosting113311053boosting
breasting1239583breasting
bunting103718833bu_nting
bushing134018583bu_shing
busing96420593bu_s_ing
busking144116573bu_sking
bussing103614623bu_ssing
bustling112110063bu_stling
busying134211993bu_sying
butting103519283bu_tting
casting104628343_casting
cessing103814813_cessing
cheating144014523cheating
cleating113518143cleating
clefting14347583clefting
coasting113615513coasting
costing104323023_costing
creating113921953creating
crestings12298043crestings
crusting113612793crusting
cueing94913613cue__ing
curating11314293curating
curetting1236573curetting
cursing104217033curs_ing
cussing103814273cu_ssing
cutting103817493cu_tting
degusting1236163degu_sting
denting94422183_denting
destine83719953_destine
destiny113111463_destiny
detesting112610323detesting
devesting14249903devesting
dieting93616833die_ting
digesting12208673digesting
divesting14298483divesting
dressing102810423dressing
ducting113713593du_cting
dueling93614543due_ling
duelling103410733duelling
dunting93418383du_nting
dusking133912053du_sking
dustings10419033du_stings
easting84924303_easting
eating75134403__eating
egressing1146853egressing
ejecting18268163ejecting
electing112113783electing
erecting112415063erecting
everting122213133everting
exerting162211153exerting
existing1639073existing
fasting114522833_fasting
feasting122011323feasting
felting113515213_felting
fessing113812863_fessing
feting104417793_fe_ting
fetting113517873_fetting
fisting113818123_fisting
fleeting122910323fleeting
fleshing15339303fleshing
foisting122910503foisting
foresting13311363foresting
freshing152611023freshing
fretting122711523fretting
frosting12311183frosting
fueling113615133fue_ling
fuelling123410153fuelling
fusing104415953fu_s_ing
fussing113611683fu_ssing
gaeing84617223gae__ing
gaiting93716583g_aiting
garoting10510703garoting
gashing125119233g_ashing
gasking134415913g_asking
gasping113714363g_asping
gassing94216333g_assing
gating84826953g__ating
gazetting2043243gazetting
gearing92818843g_earing
gecking154111363g_ecking
geeing84313773g_e_eing
gelating103015733gelating
gelding103911793g_elding
gelling93219763g_elling
gemming13289153g_emming
gentling1048453g_entling
gestating11229983g_estating
gestic9312773g_esti_c
gesturing1136653g_esturing
ghettoing1442123ghettoing
ghostings1433483ghostings
gieing83614853gie__ing
gifting123810893g_ifting
gipsying1533373gipsying
girting93113333g_irting
gitting93215703g_itting
glassing10329973glassing
gleaming12277933gleaming
gleaning10269323gleaning
gleeking14316493gleeking
gleying12318433gle_ying
glinting103210053glinting
gloating102611463gloating
glossing10278883glossing
glouting10379693glouting
glueing9338713glue__ing
glutting10247643glutting
gnashing1336423gnashing
goosing93314083goos_ing
gosling93312403g_osling
grafting13319623grafting
granting103514523granting
grasping12348833grasping
grassing103311973grassing
grating93923183g_rating
greasing102811393greasing
greeing93613783gre_eing
greening103112533greening
greetings11276043greetings
greying124110893gre_ying
grifting13299263grifting
gritting10309983gritting
grossing103111063grossing
grouting103410793grouting
grueling1078273grue_ling
gruelling1155603gruelling
grunting10269583grunting
guarding1136523guarding
guest65225923guest___
guested9157713guest_ed
guests74311203guest__s
guggling10236353guggling
guiding102911843gu_iding
guiling93214213gu_iling
gulfing12339473gu_lfing
gulling94019563gu_lling
gullwing13304923gullwing
gullying13367243gullying
gulping11309753gu_lping
gumming133810193gu_mming
gunning93413173gu_nning
gurging102910113gu_rging
gurgling11267323gurgling
gustier83813863gu_stier
gustily113010903gu_stily
guttling1037293guttling
guying11379723gu__ying
guzzling18225063guzzling
gypsying1842183gypsying
gyrating1337453gyrating
hasting114725193_hasting
heating114024323_heating
hefting144510913_hefting
heisting123411043heisting
henting113719653_henting
histing113720373_histing
hoisting123610903hoisting
hosting114318383_hosting
hunting114317123hu_nting
hurting113914033hu_rting
hushing144514473hu_shing
husking154312053hu_sking
hustings12378683hu_stings
hustling12228793hu_stling
hutting113016033hu_tting
ideating10311703ideating
infesting13109513infesting
ingesting11129623ingesting
investing13119393investing
jessing153710623_jessing
jestings16368023_jestings
jetting153815343_jetting
joisting16328503joisting
jousting16309353jousting
justling16207253ju_stling
jutting153313713ju_tting
lasting84725243_lasting
letting83218533_letting
listing84020593_listing
lunting83817743lu_nting
lushing114316113lu_shing
lustring9269723lu_string
lutestring1143473lutestring
luting75221753lu__ting
luxating1645613luxating
masting104325823_masting
meeting103314963_meeting
melting103317753_melting
meshing134513813_meshing
messing103916393_messing
mestino9411643_mestino
meting94320593_me_ting
misting103623383_misting
molesting1237753molesting
mulcting13246983mulcting
munting103718773mu_nting
mushing134217633mu_shing
musing93919503mu_s_ing
mussing104015543mu_ssing
mustang10267933mu_stang
mutating112211753mutating
muting93921523mu__ting
nestling958893_nestling
netting84018763_netting
nursing84012553nurs_ing
nursling997603nursling
nutating92411953nutating
nutting83316233nu_tting
obtesting1245883obtesting
oughting1335953oughting
outeating10814493outeating
outing74128153ou__ting
outsing83320463outs_ing
outswing1259283outswing
pasting103826553_pasting
pelting102917273_pelting
pestling111010253_pestling
petting103720953_petting
pleating112916053pleating
posting105622243_posting
pressing112516443pressing
priesting1239483priesting
pulsating1236343pulsating
pulsing103712863puls_ing
punting103318443pu_nting
pupating1337683pupating
pursing103715553purs_ing
pursuing1146233pursuing
pushing133615453pu_shing
putting103218573pu_tting
quanting1849233quanting
quashing2137093quashing
queening1846113queening
queering1838203queering
quelling18259793quelling
querying2135243querying
question1745823question
questions1845523questions
queueing1842873queueing
queuing1736233que_uing
quieting18228463quieting
quilting18218713quilting
quirting18238383quirting
quisling18218063quisling
quitting18228833quitting
quoiting1836093quoiting
quoting17310043qu_oting
renesting102514703renesting
renting84026853_renting
requesting2046313requesting
resiting93521123_resiting
restring91518783_restring
retesting102614603retesting
retting83425883_retting
reusing82516783reus_ing
revesting132814123revesting
riesling939013riesling
roasting93012703roasting
roosting93411463roosting
rousting93913273rousting
rushing113817703ru_shing
russeting1065323russeting
rustling9249983ru_stling
rutting82718043ru_tting
scenting113212813scenting
seating84130683_seating
sestina72711973_sestina
sestine73017923_sestine
setting83621393_setting
sheeting122712833sheeting
sleeting93114163sleeting
smelting11339713smelting
stetting93410713stetting
sting65330243___sting
sudsing92910323suds_ing
sueding92613753sue_ding
suggesting1343593suggesting
suiting83419003su_iting
sussing84013703su_ssing
sweating123213023sweating
sweeting123911313sweeting
tasting84624213_tasting
tenting84621153_tenting
toasting93410583toasting
treating92519613treating
trusting93411653trusting
trysting12267053trysting
tufting11289873tu_fting
tumescing1443643tumescing
tushing114214013tu_shing
tusking124212063tu_sking
tussling935823tussling
tutting83515913tu_tting
tweeting12267033tweeting
twisting12427813twisting
uniting8315823_uniting
unresting10311133unresting
unsling8313643_unsling
unstring9312093_unstring
unstung834853_unstung
upswing1335593_upswing
using66317963_u_s_ing
venting114218093_venting
vestings12359143_vestings
vetting114216563_vetting
waisting123615213waisting
wasting114422843_wasting
weeting113816053_weeting
welting113615313_welting
westings12429803_westings
wetting114117383_wetting
whetting1535973whetting
whisting15329543whisting
wisting113519743_wisting
worsting1267683worsting
wrestling1336063wrestling
yeasting12188923yeasting
yessing113210063_yessing

Search took 9 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 Filter1786911461620.440406115.9
2DLD Change Limit1461623737.93618417.6
3Display Results3733730.1562391.0
 (SQL Overall)1786913738.53220943.6
 
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.