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

362 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
garaging113904(None) 
barging114018482bar_ging
barraging1337372barraging
damaging1337382damaging
enraging1049562enraging
foraging1358062foraging
gagging93013522ga_gging
gaging94718402g__aging
ganging103216192ga_nging
garbing113613272gar_bing
garbling12249452garbling
gargling11239202gargling
garoting10510702garoting
garring93116712gar_ring
gauging10339962ga_uging
gorging102611362gor_ging
gracing113216442g_racing
grading103918712g_rading
grating93923182g_rating
graving123114562g_raving
graying124115882g_raying
grazing183514552g_razing
gurging102910112gur_ging
gyrating1337452gyrating
managing1239092managing
parading12313862parading
parawing14310582parawing
parging113318602par_ging
raging85126432__raging
ravaging1346322ravaging
savaging1356672savaging
aahing1019015763_a_ahing
abasing10610673_abasing
abating10413973_abating
abrading1239503abrading
aerating92820993aerating
aggrading1344833aggrading
aging77026353___aging
agreeing10295903agreeing
amazing1938813_amazing
arcading1239763_arcading
arching136216693_arching
arcing95819643_ar_cing
arcking145811963_arcking
argling92812733_argling
arguing9248733_arguing
arising83619973_arising
arming94719803_ar_ming
arranging1156303arranging
arraying1238743arraying
averaging1446503averaging
awaking1547813_awaking
baaing94916163ba_a_ing
badging123712793ba_dging
bagging123316983ba_gging
bandaging1436063bandaging
banging114019863ba_nging
barbing123716993bar_bing
barding113822893bar_ding
barfing134615093bar_fing
bargain1079063bargain_
bargains1178643bargains
baring95135853bar__ing
barking144724183bar_king
barning104320353bar_ning
barring104021593bar_ring
beraking153612963beraking
berating113220753berating
borating113414503borating
bracing123817613_bracing
bragging13359333bragging
braking143917703_braking
braving133714613_braving
braying134416313_braying
brazing193715113_brazing
cabbaging1744093cabbaging
cadging123610973ca_dging
caging105321023__caging
canaling112016403canaling
carabin11313213carabin_
carabine12412383carabine
carabins12312353carabins
caragana1146273caragana
carding113922433car_ding
caring95137993car__ing
carking144322853car_king
carling103727063car_ling
caroling113317003caroling
caroming133312963caroming
carping123521083car_ping
carrying14148363carrying
carting104228283car_ting
carving133916773car_ving
charging152910773char_ging
craaling112711353craaling
craning103620303_craning
craping124018713_craping
crating103725203_crating
craving134015733_craving
crazing193914583_crazing
curating11314293curating
danging103716093da_nging
daring84928683dar__ing
darking134217343dar_king
darkling1437483darkling
darling93418363dar_ling
darning93817333dar_ning
darting94020663dar_ting
dartling1039563dartling
deranging1238063deranging
derating103222273derating
dragging12308103dragging
draping114213353_draping
drawing123812053_drawing
draying123813843_draying
earing75235483ear__ing
earning83418213ear_ning
earring83519013ear_ring
earthing12310323earthing
encaging1258733encaging
engaging1147373engaging
erasing8317953_erasing
fadging134210243fa_dging
fagging133714763fa_gging
farcing133514003far_cing
farding123716743far_ding
faring105231283far__ing
farming133515083far_ming
farthing1538073farthing
farting114120753far_ting
foraying1537433foraying
forging124114723for_ging
fragging14329423fragging
framing133014793_framing
fraying143413433_fraying
gabbing133512033ga_bbing
gabbling14238073gabbling
gabling113514543ga_bling
gadding113411453ga_dding
gaeing84617223g__aeing
gaffing15379733ga_ffing
gaggling10217463gaggling
gaining94015663ga_ining
gaiting93716583ga_iting
galling93921963ga_lling
gallying13328933gallying
galoping1258023galoping
gambling14218963gambling
gaming104622043g__aming
gamming133112623ga_mming
gangling112411403gangling
gaoling93314653ga_oling
gaping105618923g__aping
gapping134214783ga_pping
garage8314513garag__e
garaged1039253garag_ed
garages9314113garag_es
gardening1236513gardening
garlanding1344433garlanding
garnering11298083garnering
garotting1136103garotting
garroting1136953garroting
gartering112111573gartering
gashing125119233ga_shing
gasking134415913ga_sking
gasping113714363ga_sping
gassing94216333ga_ssing
gasting95022763ga_sting
gating84826953g__ating
gauming11319713ga_uming
gaveling133410163gaveling
gawking16398823ga_wking
gawping14418463ga_wping
gazing174717173g__azing
gearing92818843g_earing
gelating103015733gelating
gheraoing1443523gheraoing
gigging93311773g_igging
girding103611883gir_ding
girdling1146823girdling
girning93210693gir_ning
girthing13256083girthing
girting93113333gir_ting
glaring93714883g_laring
glazing183611003g_lazing
gleaming12277933gleaming
gleaning10269323gleaning
gloaming12268013gloaming
gloating102611463gloating
glugging10316353glugging
gnarling10217603gnar_ling
gnarring10225973gnar_ring
gnawing12377903g_nawing
goading103112853g_oading
goaling93515333g_oaling
gonging103713033g_onging
goring84119573gor__ing
gorming112810833gor_ming
gouging103410703g_ouging
grabbing14267313grabbing
gradating1237313gradating
gradin83517483g_radin_
gradine93317033g_radine
gradins93416233g_radins
grafting13319623grafting
grain65126253g_ra_in_
graining102813183graining
grains74223093g_ra_ins
grainy103914213g_ra_iny
granting103514523granting
graphing1538533graphing
grasping12348833grasping
grassing103311973grassing
gratin74520583g_ratin_
gratine84719193g_ratine
gratings103910753g_ratings
gratins84119183g_ratins
grayling1338003grayling
grazings19337253g_razings
greasing102811393greasing
greeing93613783g_reeing
greying124110893g_reying
griding103014973g_riding
griming113612493g_riming
griping113012063g_riping
groaning102410283groaning
groping113313103g_roping
growing123512473g_rowing
grudging12255993grudging
guarding1136523guar_ding
gurgling11267323gurgling
gyring113910363gyr__ing
hagging133114683ha_gging
hanging123518703ha_nging
haranguing1543113haranguing
harassing1346983harassing
haring104233003har__ing
harking154120943har_king
harming133717933har_ming
harping134118383har_ping
harrying15157633harrying
homaging1536613homaging
imaging1138073_imaging
incaging1288673incaging
jagging173311993ja_gging
jarring153613193jar_ring
karting123716063kar_ting
kayaking1534053kayaking
kraaling13186663kraaling
lagging103316733la_gging
larding92917873lar_ding
lariating10311783lariating
larking123718253lar_king
marauding1344983marauding
marbling13179883marbling
marching164312193marching
margin94016843mar_gin_
margins103815193mar_gins
marking144020123mar_king
marling103322763mar_ling
marring103319543mar_ring
marrying14157213marrying
marting103325013mar_ting
massaging1346353massaging
merging112711753mer_ging
nagging102613043na_gging
narking124015383nar_king
narrating10310343narrating
oaring74225303oar__ing
orating83520323_orating
outraging111010883outraging
packaging1945163packaging
paging104020403__paging
panging113319113pa_nging
paragon10311023paragon_
paragoning1445953paragoning
paragons11311503paragons
parang93715513para__ng
parasang1147333parasang
parawings1535813parawings
parbaking1877193parbaking
parching164313053parching
pargings123410163par_gings
paring94236493par__ing
parking143423043par_king
parlaying1537303parlaying
parling103823763par_ling
paroling113316213paroling
parring103222063par_ring
parrying14168123parrying
parsing103819553par_sing
partaking1698663partaking
parting103527383par_ting
partying14168893partying
passaging1345613passaging
phrasing1438013phrasing
pirating11314513pirating
portaging1346843portaging
pranging123012723pranging
prating103424453_prating
praying133717323_praying
purging113314183pur_ging
racing95030533__racing
ragging103516683ra_gging
raking114728413__raking
rampaging1544513rampaging
ranging94120263ra_nging
raping94829853__raping
raring74332873__raring
rasing74330833__rasing
rating74938703__rating
raving105128853__raving
raxing144321023__raxing
raying105027193__raying
razing164524543__razing
sagging103116103sa_gging
salvaging1465283salvaging
scragging1435273scragging
scraping133310863scraping
serging93416673ser_ging
sparging122611133spar_ging
spraying14299883spraying
staging93818373_staging
strafing122111193strafing
strawing122411623strawing
straying122912693straying
surging93115433sur_ging
swaging124210633_swaging
tagging103014913ta_gging
tallaging1146483tallaging
tanging93419523ta_nging
taring73932283tar__ing
tarring83318303tar_ring
tarrying12146713tarrying
tarting84222653tar_ting
thrawing1535963thrawing
tracing103720153_tracing
trading93517973_trading
triaging102610543triaging
unaging9510933_unaging
uncaging1268713uncaging
uprating11311113uprating
urging83413123_ur_ging
vacating14310343vacating
variating13310933variating
varying1429723var_ying
verging123812303ver_ging
voyaging1632553voyaging
wagging133313353wa_gging
waging114318383__waging
warbling14198943warbling
warding123918143war_ding
waring105029443war__ing
warking153519573war_king
warming133515083war_ming
warning113717093war_ning
warping133715183war_ping
warring113717973war_ring
warsling12198593warsling
yarding123413143yar_ding
yarning113512953yar_ning
zagging193210453za_gging

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.1601116818.8
2DLD Change Limit1461623627.60619216.7
3Display Results3623620.1562320.5
 (SQL Overall)1786913627.92222556.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.