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

214 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
garbage113805(None) 
garage8314511gar_age
garbages1238181garbages
garbagey1543371garbagey
garbagy1444241garbagy
ambage11510602_ambage
barbate11314542barbate
barrage10710842barrage
cabbage1446982cabbage
carnage10311742carnage
cartage10312592cartage
gambade1336382gambade
gamboge1335582gamboge
garaged1039252gar_aged
garages9314112gar_ages
garble94118452garb_le
gasbag1035412gasbag_
gasbags1135472gasbags
gavage1137192ga_vage
herbage1337002herbage
parbake1538352parbake
warpage1336402warpage
yardage1235732yardage
abase76023483_a_base
abate76627843_a_bate
abrade9313053_abrade
acreage1037843acreage
adage7414053_a_dage
agrafe1038093agr_afe
airbag956963airbag_
airbags1036293airbags
ambages1269623_ambages
anlage72514233_anlage
arable81821003_arable
arame75026623_ar_ame
arbute8311043_arbute
arcade91013643_arcade
arcane81216743_arcane
areae55229743_area_e
arrange838683_arrange
aubade939223_aubade
baggage1235633baggage
bandage11311023bandage
barbal104016663barba_l
barbe95328283barb__e
barbie105018353barb_ie
barbule1137943barbule
barege94713543bar_ege
barge85631023bar__ge
baronage1147073baronage
barraged1297683barraged
barrages11711083barrages
barware12610703barware
borage93917013bor_age
burgage1136633burgage
cabbaged1644383cabbaged
cabbages1537203cabbages
cabbagey1843213cabbagey
cabbagy1744013cabbagy
carafe115416163car_afe
carate84734003car_ate
carbarn1139453carbarn
carbide126112493carbide
carbine112918643carbine
carcase11312733carcase
carfare12310073carfare
carnages11312213carnages
carpale113414353carpale
carriage1137853carriage
cartages11313313cartages
cordage11310063cordage
corkage1438373corkage
corsage1039803corsage
cubage1178273_cubage
damage10410773da_mage
darbar959953darba_r
darbars10510093darbars
drayage1234423drayage
enrage72715073enr_age
farrago1144923farrago
forage104617003for_age
forbade13259103forbade
forbare122310513forbare
gabbard1336553gabbard
gabbart1248883gabbart
gabble113815723ga_bble
gable85325523ga_b_le
gage65936103g___age
galago838903ga_lago
galeae74717453galea_e
galeate83916783galeate
gallate83417123gallate
gamba106018513gamba__
gambades1435863gambades
gambado1344973gambado
gambas115817513gamba_s
gambe106219213gamb__e
gamble115417183gamb_le
gamboges1435653gamboges
garb75332673garb___
garbageman1671263garbageman
garbagemen1671773garbagemen
garbanzo2042583garbanzo
garbed104815663garb_ed
garbing113613273garbing
garbled114512803garbled
garbler104012563garbler
garbles104016923garbles
garboard1247243garboard
garboil1036513garboil
garbs86321413garb__s
garda7316763garda__
gardai839663garda_i
gardant9314463gardant
garganey1344883garganey
garget84327273gar__get
gargle84215463gar_gle
garigue935583garigue
garland948703garland
garote7717953gar_ote
garotte868703garotte
garpike1435093garpike
garrote8510103garrote
gauge76117903ga__uge
gavages1237683ga_vages
gearcase1154453gearcase
germane1049663germane
glabrate1146033glabrate
glebae9407613gleba_e
globate1057823globate
gorge76423893gor__ge
grabble12339643grabble
grace85124543g_r_ace
gradate9511233gradate
grade75126093g_r_ade
graftage1343683graftage
grange83716203g_range
grape84824663g_r_ape
grate64932883g_r_ate
grave94624873g_r_ave
graze155820053g_r_aze
grease75416233g_rease
greave104611493g_reave
greige847203g_reige
grudge9388583g_rudge
grunge8359583g_runge
gurge75419783gur__ge
gyrase10508773gyr_ase
gyrate104912523gyr_ate
harborage1544653harborage
haulage1136913haulage
haylage1436443haylage
herbaged1554523herbaged
herbages1437093herbages
karate105320923kar_ate
large65325463lar__ge
larvae938843larva_e
lavage1038263la_vage
manage93818903ma_nage
marble104219103marb_le
marge85328333mar__ge
marriage1147253marriage
massage1039893massage
mirage92313653mir_age
narrate7313493narrate
package16128013package
parable111819773parable
parade94720643par_ade
parae76335703par_a_e
parbaked1735503parbaked
parbakes1638343parbakes
parge85831853par__ge
parkade1437583parkade
partake1339643partake
passage1039803passage
pawnage1335873pawnage
portage103013643portage
ragbag1045463ragbag_
ragbags1135113ragbags
rage55742353__r_age
rampage1237453rampage
ratbag956563ratbag_
ratbags1035763ratbags
ravage1039303ra_vage
salvage1138193salvage
sarape84817573sar_ape
sarge65531133sar__ge
sausage847193sausage
savage10410173sa_vage
serfage1138403serfage
sorbate9311733sorbate
surbase939793surbase
tallage82712073tallage
tankage12257773tankage
tannage8209583tannage
targe65227093tar__ge
tartare73012683tartare
triage72812893_triage
umbrage1236723umbrage
urbane82211383_urbane
vantage11109893vantage
variate101316433variate
verbiage1444553verbiage
vorlage1136403vorlage
waftage14115323waftage
wantage11119623wantage
warble113516603warb_le
warfare1336733warfare
warpages1437053warpages
wastage11109253wastage
wattage1186983wattage
wharfage1842213wharfage
wordage1236503wordage
yardages1336203yardages

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 Limit1340272146.58020368.8
3Display Results2142140.0762815.8
 (SQL Overall)1786912147.06225303.2
 
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.