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

324 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
egesting103901(None) 
agenting1039382agenting
agisting1038242agisting
begetting13186582begetting
besting104923922_besting
cresting114017042cresting
degusting1236162degusting
detesting112610322detesting
devesting14249902devesting
digesting12208672digesting
easting84924302e_asting
egestion946862egestion
egestions1046702egestions
egestive1246832egestive
egressing1146852egressing
ejecting18268162ejecting
electing112113782electing
erecting112415062erecting
everting122213132everting
exerting162211152exerting
existing1639072existing
gasting95022762_gasting
getting93316562_getting
guesting1058462guesting
gusting93917162_gusting
ingesting11129622ingesting
jesting154317712_jesting
nesting84320442_nesting
questing1838272questing
reesting93118272reesting
renesting102514702renesting
resting85031182_resting
retesting102614602retesting
revesting132814122revesting
testing86021052_testing
vesting114618682_vesting
westing115020272_westing
wresting123811832wresting
zesting174515332_zesting
abetting1158293abetting
ageing84213403age__ing
agentings1134443agentings
alerting91312383alerting
arresting1038633arresting
attesting1036383attesting
averting122512733averting
basting104227203_basting
beating104326873_beating
beestings12335923beestings
beeswing14255763beeswing
belting104119133_belting
bemisting1438073bemisting
besetting12268423besetting
betting103921403_betting
biestings12266033biestings
blasting114013433blasting
bleating113514503bleating
blessing1137593blessing
boasting113512503boasting
boosting113311053boosting
breasting1239583breasting
bursting1138703bursting
busting104221793_busting
casting104628343_casting
celestine11147943celestine
cementing1438763cementing
cessing103814813_cessing
cheating144014523cheating
cleating113518133cleating
clefting14347583clefting
coasting113615513coasting
congesting14410113congesting
costing104323023_costing
creating113921953creating
crestings12298043crestings
crusting113612793crusting
defeating142311973defeating
defecting162510223defecting
degassing1234823degassing
degerming1435753degerming
dejecting20217793dejecting
deleting103314423dele_ting
delisting112710503delisting
demasting1338453demasting
dementing13311043dementing
denting94422183_denting
deserting11713143deserting
desisting112810383desisting
destine83719953_destine
destiny113111463_destiny
detecting13259983detecting
dieting93616833die_ting
divesting14298483divesting
dressing102810423dressing
dueting93814393due_ting
duetting1047183duetting
dusting93618993_dusting
easing74926463e_as_ing
eastings93412953e_astings
eating75134403__eating
editing9313133e_diting
effecting1845583effecting
egest65222343egest___
egesta7428653egest__a
egested938123egest_ed
egests74411253egest__s
egging93210983eg__ging
elastin72611843elastin_
elastins82111743elastins
elating83423083e_lating
elevating1338203elevating
eluting84115293e_luting
emending12298893emending
emerging1237893emerging
emetin8613463eme_tin_
emetine9712943eme_tine
emetins9812653eme_tins
emitting112410353emitting
emoting10313563e_moting
enacting11311363enacting
encysting1544613encysting
enditing10311073enditing
enisling949633enisling
enlisting1038343enlisting
enmeshing15114873enmeshing
ensuing8239543e_nsuing
equating18310113equating
erasing8317963eras_ing
eructing112110173eructing
erupting11218443erupting
escoting1158713escoting
estating92614993estating
evening11310223eve_ning
evicting1437483evicting
eviting11511373e_viting
exacting1838523exacting
exalting1638033exalting
excepting2145873excepting
excessing1945713excessing
exciting1838023exciting
executing1945583executing
exempting2144223exempting
exiting15311393e_xiting
expecting2146693expecting
experting1938053experting
exsecting1935933exsecting
exserting1736663exserting
exulting1637643exulting
eyeing10429363eye__ing
eyeshine1444543eyeshine
eyestone1146533eyestone
eyestrings1462773eyestrings
fasting114522833_fasting
feasting122011323feasting
felting113515213_felting
fessing113812863_fessing
feting104417793_fe_ting
fetting113517873_fetting
fisting113818123_fisting
fleeting122910323fleeting
fleshing15339303fleshing
foisting122910503foisting
foresting13311363foresting
freshing152611023freshing
fretting122711523fretting
frosting12311183frosting
gaiting93716583_gaiting
gashing125119233_gashing
gasking134415913_gasking
gasping113714363_gasping
gassing94216333_gassing
gating84826953_g_ating
gearing92818843_gearing
gecking154111363_gecking
geeing84313773_ge_eing
gelating103015733gelating
gelding103911793_gelding
gelling93219763_gelling
gemming13289153_gemming
gentling1048453_gentling
gestating11229983_gestating
gestic9312773_gesti_c
gesturing1136653_gesturing
ghosting1336463ghosting
gifting123810893_gifting
girting93113333_girting
gitting93215703_gitting
gleeting10279173gleeting
gosling93312403_gosling
grating93923183_grating
greeting103112353greeting
guessing1036243guessing
gushing124014223_gushing
gutting93415923_gutting
hasting114725193_hasting
heating114024323_heating
hefting144510913_hefting
heisting123411043heisting
henting113719653_henting
histing113720373_histing
hoisting123610903hoisting
hosting114318383_hosting
ideating10311703ideating
igniting1037363igniting
infesting13109513infesting
investing13119393investing
jessing153710623_jessing
jestings16368023_jestings
jetting153815343_jetting
joisting16328503joisting
jousting16309353jousting
justing153615163_justing
lasting84725243_lasting
legating102313113leg_ating
letting83218533_letting
listing84020593_listing
lusting83619323_lusting
masting104325823_masting
meeting103314963_meeting
melting103317753_melting
meshing134513813_meshing
messing103916393_messing
mestino9411643_mestino
meting94320593_me_ting
misting103623383_misting
molesting1237753molesting
musting103221073_musting
negating102012833neg_ating
neglecting1444543neglecting
nestling958893_nestling
netting84018763_netting
obtesting1245883obtesting
ousting84021353_ousting
pasting103826553_pasting
pelting102917273_pelting
pestling111010253_pestling
petting103720953_petting
pleating112916053pleating
posting105622243_posting
pressing112516443pressing
pretesting131810683pretesting
priesting1239483priesting
recasting122414233recasting
recessing12611013recessing
redigesting1444573redigesting
refecting152413353refecting
regearing112211413regearing
regelating1239953regelating
regrating111316213regrating
regreeting1237343regreeting
regressing1248143regressing
regretting1237783regretting
reheating132314913reheating
rejecting192211153rejecting
relenting102716773relenting
reletting102713943reletting
relisting102414353relisting
remeeting12311433remeeting
remelting12311703remelting
renting84026853_renting
repasting122312843repasting
repeating122618983repeating
repenting122316553repenting
requesting2046313requesting
rerenting102617663rerenting
reseating102421533reseating
resecting122816483resecting
resenting102619293resenting
resetting102816293resetting
resisting103215313resisting
resiting93521123_resiting
restring91518783_restring
retasting102513413retasting
retting83425883_retting
reverting132315133reverting
revetting132912633revetting
rewetting132710443rewetting
riesling939013riesling
roasting93012703roasting
roosting93411463roosting
rousting93913273rousting
rusting83821263_rusting
scenting113212813scenting
seating84130683_seating
segmenting1445003segmenting
selecting12310533selecting
sestina72711973_sestina
sestine73017923_sestine
setting83621393_setting
sheeting122712833sheeting
sleeting93114163sleeting
smelting11339713smelting
stetting93410713stetting
sting65330243___sting
suggesting1343593suggesting
sweating123213023sweating
sweeting123911313sweeting
tasting84624213_tasting
tempesting1544453tempesting
tenting84621153_tenting
toasting93410583toasting
treating92519613treating
trusting93411653trusting
trysting12267053trysting
tweeting12267033tweeting
twisting12427813twisting
unresting10311133unresting
vegetating1545703vegetating
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 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 Filter1786911461620.420425454.8
2DLD Change Limit1461623246.87621256.8
3Display Results3243240.1402314.3
 (SQL Overall)1786913247.43624030.5
 
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.