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

203 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
garbages123818(None) 
garages9314111gar_ages
garbage1138051garbage_
garbagey1543371garbagey
ambages1269622_ambages
barrages11711082barrages
cabbages1537202cabbages
carnages11312212carnages
cartages11313312cartages
gambades1435862gambades
gamboges1435652gamboges
garage8314512gar_age_
garaged1039252gar_aged
garbagy1444242garbag_y
garbles104016922garb_les
gasbags1135472gasbag_s
gavages1237682ga_vages
herbages1437092herbages
parbakes1638342parbakes
warpages1437052warpages
yardages1336202yardages
abases85720773_a_bases
abates85825033_a_bates
abrades10312073_abrades
acreages1138373acreages
adages8412953_a_dages
agrafes1137523agr_afes
airbags1036293airbag_s
ambage11510603_ambage_
anlages82414113_anlages
arables91814973_arables
arames84622573_ar_ames
arbalest1039523_arbalest
arbores94016033_arbores
arbutes939703_arbutes
arcades101113193_arcades
arranges939413_arranges
arrases71214543_arrases
aubades1038753_aubades
baggages1335443baggages
bandages12310633bandages
barbate11314543barbate_
barbes104526233barb__es
barbies114519593barb_ies
barbules1238043barbules
bareges105212033bar_eges
barges94528253bar__ges
baronages1247153baronages
barrage10710843barrage_
barraged1297683barraged
barwares13610093barwares
borages103917163bor_ages
burgages1236483burgages
cabbage1446983cabbage_
cabbaged1644383cabbaged
cabbagey1843213cabbagey
carafes125015703car_afes
carates95630613car_ates
carbarns1238563carbarns
carbides133111693carbides
carbines123617533carbines
carcases12313093carcases
carfares13310323carfares
carnage10311743carnage_
carriages1238333carriages
cartage10312593cartage_
cordages12310113cordages
corkages1539103corkages
corsages11310363corsages
cubages1237923_cubages
damages11511273da_mages
darbars10510093darba_rs
darbies104216983darb_ies
drayages1344503drayages
earwaxes1844703earwaxes
enrages83114853enr_ages
farragoes1344633farragoes
forages114217283for_ages
gabbards1445753gabbards
gabbarts1344063gabbarts
gabbles124415413ga_bbles
gabies93820733ga_b_ies
gables94222333ga_b_les
gages74529973g___ages
galagos938143ga_lagos
galaxes1538873ga_laxes
gallates92815523gallates
gambade1336383gambade_
gambadoes1542833gambadoes
gambados1444153gambados
gambas115817513gamba__s
gambes116318313gamb__es
gambles124016203gamb_les
gamboge1335583gamboge_
garbageman1671263garbageman
garbagemen1671773garbagemen
garbanzo2042583garbanzo
garbanzos2141953garbanzos
garbed104815663garb__ed
garble94118453garb_le_
garbled114512803garb_led
garbler104012563garb_ler
garblers113810283garblers
garbless11388253garbless
garboards1346363garboards
garboils1145663garboils
garbs86321413garb___s
garganey1344883garganey
garganeys1442613garganeys
garget84327273gar__get
gargets94614573gar__gets
gargles94214893gar_gles
garigues1034953garigues
garlands1038323garlands
garotes8614563gar_otes
garottes978283garottes
garpikes1534373garpikes
garrotes969363garrotes
gasbag1035413gasbag__
gauges85915993ga__uges
gavage1137193ga_vage_
gazaboes2043863gazaboes
gearboxes1942933gearboxes
gearcases1254693gearcases
gorges85321893gor__ges
grabbles13339893grabbles
graces94523493g_r_aces
gradates10510783gradates
grades84926313g_r_ades
graftages1443683graftages
granges93516523g_ranges
grapes95123123g_r_apes
grates75429893g_r_ates
graves104624003g_r_aves
grazes164519643g_r_azes
greases84816713g_reases
greaves113311443g_reaves
greiges937733g_reiges
grudges10349423g_rudges
grunges93310403g_runges
gurges84716863gur__ges
gyrases11368313gyr_ases
gyrates113610263gyr_ates
harborages1644523harborages
haulages1236623haulages
haylages1536013haylages
herbage1337003herbage_
herbaged1554523herbaged
karates115617473kar_ates
larges74824233lar__ges
larynges1244503larynges
lavages1138603la_vages
manages103418963ma_nages
marbles114516653marb_les
marges94525713mar__ges
marriages1247383marriages
massages1159883massages
mirages102213533mir_ages
narrates8312763narrates
packages17138733packages
parables121613563parables
parades104121463par_ades
parbake1538353parbake_
parbaked1735503parbaked
parges94529543par__ges
parkades1538273parkades
partakes1449923partakes
passages1139513passages
pawnages1435313pawnages
portages112613223portages
ragbags1135113ragbag_s
rages64539443__r_ages
rampages1336673rampages
ratbags1035763ratbag_s
ravages1139403ra_vages
salvages1238123salvages
sarapes94617743sar_apes
sarges75128593sar__ges
sausages937003sausages
savages1139973sa_vages
serfages1238233serfages
sorbates10311103sorbates
surbases10310003surbases
tallages92312003tallages
tankages13217113tankages
tannages9228963tannages
targes74524593tar__ges
triages82613793_triages
umbrages1336623umbrages
vantages12119023vantages
variates111214983variates
verbiages1544683verbiages
vorlages1236033vorlages
waftages15105393waftages
wantages12109023wantages
warbles123215563warb_les
warfares1436683warfares
warpage1336403warpage_
wastages12109753wastages
wattages12106783wattages
wharfages1942633wharfages
wordages1337053wordages
yardage1235733yardage_

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.470380193.6
2DLD Change Limit1461622036.48322545.4
3Display Results2032030.0802537.5
 (SQL Overall)1786912037.03325407.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.