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

388 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
guarding113652(None) 
awarding1356042awarding
barding113822892_barding
bearding124011942bearding
boarding123110232boarding
carding113922442_carding
curding113515132cu_rding
farding123716742_farding
gadding113411452g_adding
garbing113613272g_arbing
garring93116712g_arring
gearing92818842gear_ing
girding103611882g_irding
gladding1236302gladding
glaring93714882glar_ing
gnarling10217602gnarling
gnarring10225972gnarring
goading103112852goa_ding
grading103918712gra_ding
guardant1046442guardant
guarddog1241682guarddog
guardian1045112guardian
guardians1143912guardians
guiding102911842gu_iding
gurging102910112gu_rging
hoarding13288642hoarding
larding92917872_larding
quadding2035362quadding
swarding1359002swarding
unguarding1343532unguarding
warding123918142_warding
yarding123413142_yarding
abrading1239503abrading
adding93914963__adding
aggrading1344843aggrading
aiding84423613__aiding
alarming1138583alarming
arcing95819643__arcing
arming94719803__arming
auding83616933__auding
balding114015063_balding
banding114921413_banding
barbing123716993_barbing
barfing134615093_barfing
barging114018483_barging
baring95135853_bar_ing
barking144724183_barking
barning104320353_barning
barring104021593_barring
beading113221863bea_ding
bearing103624773bear_ing
birding114014923_birding
blading113615363bla_ding
blaring104317113blar_ing
boardings13296063boardings
bradding13268933bradding
braiding123112703braiding
branding122513683branding
budding123712403bu_dding
building1237503building
burking143716323bu_rking
burling104421133bu_rling
burning104215503bu_rning
burping124012943bu_rping
burring104016993bu_rring
burying133413913bu_rying
cardings123812643_cardings
caring95137993_car_ing
carking144322853_carking
carling103727063_carling
carping123521083_carping
carting104228283_carting
carving133916773_carving
charging152910773charging
charing133721323char_ing
charking183512613charking
charming163012033charming
charring142913163charring
charting142614193charting
chording15410153chording
cladding1337143cladding
cording113620823_cording
curating11314293curating
curbing123814023cu_rbing
curdling12228893cu_rdling
curing94824783cu_r_ing
curling104320183cu_rling
curring103616843cu_rring
currying14196493currying
cursing104217033cu_rsing
curving133912103cu_rving
daring84928683_dar_ing
darking134217343_darking
darling93418363_darling
darning93817333_darning
darting94020663_darting
duding93913323du__ding
during84419403du_r_ing
durning93511733du_rning
dwarfing1633613dwarfing
earing75235483_ear_ing
earning83418213_earning
earring83519013_earring
evading1237283eva_ding
fading114821113_fa_ding
farcing133514003_farcing
faring105231283_far_ing
farming133515083_farming
farting114120753_farting
fearing113520033fear_ing
flaring114116803flar_ing
fording123717043_fording
funding124113663fu_nding
furling114016563fu_rling
furring114013143fu_rring
gabardine1343713gabardine
gabbing133512033g_abbing
gabling113514543g_abling
gaeing84617223g_a_eing
gaffing15379733g_affing
gagging93013533g_agging
gaging94718403g_a_ging
gaining94015663g_aining
gaiting93716583g_aiting
galling93921963g_alling
gaming104622043g_a_ming
gamming133112623g_amming
ganging103216193g_anging
gaoling93314653g_aoling
gaping105618923g_a_ping
gapping134214783g_apping
garaging1139043g_araging
garbling12249453g_arbling
gardant9314463g_ardant
garden84215083g_arden_
gardening1236513g_ardening
gardens93312093g_ardens
gargling11239203g_argling
garoting10510703g_aroting
gashing125119233g_ashing
gasking134415913g_asking
gasping113714363g_asping
gassing94216333g_assing
gasting95022763g_asting
gating84826953g_a_ting
gauging10339963g_auging
gauming11319713g_auming
gawking16398823g_awking
gawping14418463g_awping
gazing174717173g_a_zing
gearings10359503gear_ings
gelding103911793g_elding
giardia945563giardi_a
giardias1045023giardias
gilding103813003g_ilding
girdling1146823g_irdling
girning93210693g_irning
girting93113333g_irting
glaceing1236533glaceing
glairing1047283glairing
glancing1247063glancing
glassing10329973glassing
glazing183611003gla_zing
gliding103911843g_liding
glorying1335543glorying
gnashing1336423gnashing
gnawing12377903gna_wing
goaling93515333goa_ling
godding113911943g_odding
gorging102611363g_orging
goring84119573g_or_ing
gorming112810833g_orming
grabbing14267313grabbing
gracing113216443gra_cing
gradin83517483gra_din_
gradine93317033gra_dine
gradins93416233gra_dins
grafting13319623grafting
graining102813183graining
granting103514523granting
graphing1538533graphing
grasping12348833grasping
grassing103311973grassing
grating93923183gra_ting
graving123114563gra_ving
graying124115883gra_ying
grayling1338003grayling
grazing183514553gra_zing
griding103014973g_riding
grinding1139863grinding
guanidin1044193guanidin_
guanidine1144043guanidine
guanidins1143663guanidins
guanin7610803gua_nin_
guanine8810543gua_nine
guanins8810013gua_nins
guarana886303guar_ana
guarani8106273guar_ani
guaranis996863guaranis
guard74415543guard___
guardants1143793guardants
guarddogs1351513guarddogs
guarded1036153guard_ed
guarder936463guard_er
guarders1035883guarders
guards84611573guard__s
guerdon944343guerdon_
guerdoning1362363guerdoning
guerdons1044233guerdons
guessing1036243guessing
guesting1058463guesting
guggling10236353guggling
guiling93214213gu_iling
guising93511413gu_ising
gulfing12339473gu_lfing
gulling94019563gu_lling
gullwing13304923gullwing
gullying13367243gullying
gulping11309753gu_lping
gumming133810193gu_mming
gunning93413173gu_nning
gurgling11267323gurgling
gushing124014223gu_shing
gussying1334063gussying
gusting93917163gu_sting
gutting93415923gu_tting
guttling1037293guttling
guying11379723gu__ying
guzzling18225063guzzling
gyrating1337453gyrating
gyring113910363g_yr_ing
hading113922943_ha_ding
handing123518893_handing
haring104233003_har_ing
harking154120943_harking
harming133717933_harming
harping134118383_harping
hazarding2343403hazarding
heading122919113hea_ding
hearing113324163hear_ing
hearsing1239383hearsing
hearting12513123hearting
herding122915123_herding
hoardings14315113hoardings
hording123517053_hording
hurdling13288013hu_rdling
hurling113616413hu_rling
hurrying15145533hurrying
hurting113914033hu_rting
inarming1138343inarming
jading154214023_ja_ding
jarring153613193_jarring
jurying18337763ju_rying
karting123716063_karting
lading84227123_la_ding
landing92819323_landing
larking123718253_larking
lauding93211903_lauding
leading93419553lea_ding
learning978553learning
loading94114613loa_ding
lording93115233_lording
luring73820753lu_r_ing
lurking123710853lu_rking
madding123711993_madding
marking144020133_marking
marling103322763_marling
marring103319553_marring
marting103325013_marting
mudding123310813mu_dding
muring95120373mu_r_ing
nardine82712573_nardine
narking124015383_narking
nearing83020333near_ing
niggarding1442353niggarding
nurling84215823nu_rling
nursing84012553nu_rsing
oaring74225303_oar_ing
outadding1235793outadding
outriding11310623outriding
outring84021023outr_ing
padding123412513_padding
parading12313863_parading
pardine103616723_pardine
parging113318603_parging
paring94236493_par_ing
parking143423043_parking
parling103823763_parling
parring103222063_parring
parsing103819553_parsing
parting103527383_parting
pearling11912013pearling
pharming16248143pharming
pudding124010803pu_dding
purging113314183pu_rging
purling103620293pu_rling
purring104515823pu_rring
pursing103715553pu_rsing
quacking2436743quacking
quaffing2434353quaffing
quailing1838403quailing
quaking2139313qua_king
quandang1943293quandang
quandong1942943quandong
quanting1849233quanting
quarrying2273733quarrying
quashing2137093quashing
querying2135243querying
quiring17159993quir_ing
quirking22215123quirking
quirting18238383quirting
radding103715003_radding
raiding93617593_raiding
raring74332873_rar_ing
readding11411363readding
reading93327213rea_ding
rearing83128783rear_ing
rearming111413613rearming
regarding12149153regarding
retarding111110653retarding
rewarding14148833rewarding
roaring82916003roar_ing
sanding93520603_sanding
sardine83317393_sardine
scalding12339393scalding
scarfing14309713scarfing
scaring103421973scar_ing
scarping133312463scarping
scarring112511513scarring
scarting113415263scarting
searing83330923sear_ing
shading123115563sha_ding
sharing113723243shar_ing
sharking163912973sharking
sharping143011373sharping
smarting113212453smarting
snarfing12358663snarfing
snaring83920953snar_ing
snarling92513183snarling
soaring83521893soar_ing
spading113114383spa_ding
sparging122611133sparging
sparing104823873spar_ing
sparking152812543sparking
sparling112714533sparling
sparring113112223sparring
squadding2143233squadding
squaring18158633squar_ing
standing103413633standing
staring84527053star_ing
starling93017123starling
starring92312953starring
starting93116173starting
starving122510173starving
subring104116263subr_ing
sueding92613753su_eding
sugaring1039053sugar_ing
surfing112914483su_rfing
surging93115433su_rging
swarming1458223swarming
taring73932283_tar_ing
tarring83318303_tarring
tarting84222653_tarting
tearing84021493tear_ing
trading93517973tra_ding
turdine8310283tu_rdine
turfing113010053tu_rfing
turning83713183tu_rning
unarming1138623unarming
urging83413123_u_rging
urping93914053_u_rping
varying1429723_varying
wadding133711943_wadding
wading114619533_wa_ding
waring105029443_war_ing
warking153519573_warking
warming133515083_warming
warning113717093_warning
warping133715183_warping
warring113717973_warring
wearing113318863wear_ing
wearying1546703wearying
weirding1335593weirding
wharfing1834683wharfing
wording123014563_wording
yarning113512953_yarning
yearling1297883yearling
yearning1296983yearning

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.423422437.4
2DLD Change Limit1461623886.72021750.3
3Display Results3883880.1562487.2
 (SQL Overall)1786913887.29924481.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.