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

147 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
cabbage144698(None) 
cabbaged1644381cabbaged
cabbages1537201cabbages
cabbagey1843211cabbagey
cabbagy1744011cabbagy
ambage11510602_ambage
cabbala1367182cabbala
cabbie122913352cabb_ie
cabotage1345222cabotage
carnage10311742carnage
cartage10312592cartage
cribbage1542972cribbage
cubage1178272c_ubage
garbage1138052garbage
abase76023483_a_base
abate76627843_a_bate
abba810522653_abba__
abbacy1536623_abbacy
abbas95918643_abba_s
abbe87627193_abb__e
ablate82219213_ablate
ablaze17239833_ablaze
abrade9313053_abrade
acreage1037843acreage
adage7414053_a_dage
ambages1269623_ambages
anlage72514233_anlage
aubade939223_aubade
babble94017113babb_le
baggage1235633baggage
bandage11311023bandage
barbate11314543barbate
barrage10710843barrage
cabal95222153ca_ba_l
cabala103516913ca_bala
cabals104020153ca_bals
cabana103913563ca_bana
cabaret112519043ca_baret
cabbaging1744093cabbaging
cabbalah1763793cabbalah
cabbalas1467373cabbalas
cabbed135416263cabb_ed
cabbies133115163cabbies
cabbing143613153cabbing
cabby145314563cabb__y
cable95329913ca_b_le
cabman123812503cabma_n
caboose1138273caboose
cabotages1444853cabotages
cadge94018793ca__dge
cage75339063c___age
campagne1544413campagne
canape10913513ca_nape
capable13313363capable
carafe115416163ca_rafe
carate84734003ca_rate
carbarn1139453carbarn
carbide126112493carbide
carbine112918643carbine
carcase11312743carcase
carfare12310073carfare
carnages11312213carnages
carpale113414353carpale
carriage1137853carriage
cartages11313313cartages
casbah1337903casba_h
casbahs1436463casbahs
cascade12118603cascade
casease939323casease
caseate9314783caseate
catface1436763catface
caudate10311353caudate
caviare1238373caviare
chantage1446633chantage
clambake1843893clambake
cobble123615263cobb_le
coinage10310553coinage
collage102813763collage
cordage11310063cordage
corkage1438373corkage
corsage1039803corsage
cottage104210573cottage
courage10310993courage
cowage12310673c_owage
cowbane1437673cowbane
cowhage1636303cowhage
cribbages1642763cribbages
cubages1237923c_ubages
cuttage10318343cuttage
dabble114515193dabb_le
damage10410773da_mage
gabbard1336553gabbard
gabbart1248883gabbart
gabble113815723gabb_le
gambade1336383gambade
gamboge1335583gamboge
garage8314513ga_rage
garbages1238183garbages
garbagey1543373garbagey
garbagy1444243garbagy
gasbag1035413gasbag_
gasbags1135473gasbags
gavage1137193ga_vage
haulage1136913haulage
haylage1436443haylage
herbage1337003herbage
kabbala1584613kabbala
labiate91313573labiate
lavage1038263la_vage
manage93818903ma_nage
massage1039893massage
package16128013package
parbake1538353parbake
passage1039803passage
pawnage1335873pawnage
rabble103818243rabb_le
ragbag1045463ragbag_
ragbags1135113ragbags
rampage1237453rampage
ratbag956563ratbag_
ratbags1035763ratbags
ravage1039303ra_vage
sabbat10314713sabba_t
sabbath1445393sabbath
sabbats1138633sabbats
sabotage1144603sabotage
salvage1138193salvage
sausage847193sausage
savage10410173sa_vage
scabbard1544203scabbard
scabble13168653scabb_le
scalage103110533sca_lage
subbase1139323subbase
tallage82712073tallage
tankage12257773tankage
tannage8209583tannage
umbrage1236723umbrage
vantage11109893vantage
wabble133714843wabb_le
waftage14115323waftage
wantage11119623wantage
warpage1336403warpage
wastage11109253wastage
wattage1186983wattage
webpage1543133webpage
yabbie13308663yabb_ie
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 Filter1786911340270.593301333.9
2DLD Change Limit1340271476.61020276.4
3Display Results1471470.0463195.7
 (SQL Overall)1786911477.24924650.4
 
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.