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

344 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
cartage1031259(None) 
carnage10311741carnage
cartages11313311cartages
acreage1037832acreage
barrage10710842barrage
cabbage1446982cabbage
cabotage1345222cabotage
carafe115416162car_afe
carate84734002car_ate
carcase11312732carcase
caretake1446772caretake
carfare12310072carfare
carnages11312212carnages
carpale113414352carpale
carriage1137852carriage
cartable121314092cartable
carte75940422cart__e
cartilage1245532cartilage
chantage1446632chantage
cordage11310062cordage
corkage1438372corkage
corsage1039802corsage
cortege1098942cortege
cottage104210572cottage
curtate9312642curtate
cuttage10318342cuttage
garage8314512gar_age
garbage1138052garbage
partake1339642partake
portage103013642portage
tartare73012682tartare
vantage11109892vantage
waftage14115322waftage
wantage11119622wantage
warpage1336402warpage
wastage11109252wastage
wattage1186982wattage
yardage1235732yardage
acetate92514753acetate
acreages1138363acreages
adage7414053_a_dage
ambage11510603_ambage
anlage72514223_anlage
antae56828293_anta_e
aortae65115473aorta_e
arame75026623_ar_ame
arcade91013643_arcade
arcane81216743_arcane
areae55229743_area_e
arrange838683_arrange
artal55525473_arta_l
baggage1235633baggage
bandage11311023bandage
barbate11314543barbate
barege94713543bar_ege
barge85631023bar__ge
baronage1147073baronage
barraged1297683barraged
barrages11711083barrages
barware12610703barware
borage93917013bor_age
burgage1136633burgage
cabbaged1644383cabbaged
cabbages1537203cabbages
cabbagey1843213cabbagey
cabbagy1744013cabbagy
cabotages1444853cabotages
cadge94018783ca__dge
caftan111710123cafta_n
caftaned1445093caftaned
caftans12179443caftans
cage75339063c___age
campagne1544413campagne
canape10913513ca_nape
cantal84122033canta_l
cantala94114673cantala
cantals93919573cantals
cantata93811813cantata
cantle84522153cant_le
capitate121712183capitate
captain112111053captain
captan101613343capta_n
captans111612053captans
captive1438973captive
capture1138903capture
carack142113173car_ack
carafes125015703car_afes
carageen1155633car_ageen
caramel11310253car_amel
carapace1446083carapace
carat75048793car_a_t
carates95630603carates
carats85929023car_ats
caravel1238203car_avel
carbarn1139453carbarn
carbide126112493carbide
carbine112918643carbine
carcanet12316343carcanet
carcases12313083carcases
carcass11310513carcass
cardcase1345963cardcase
cardiae10713703cardiae
care66968373car___e
caretaken1543633caretaken
caretaker1545083caretaker
caretakes1547143caretakes
carfares13310323carfares
cargo85322073car__go
caribe103416753car_ibe
carinae94318583carinae
carinate103320243carinate
caring95137993caring_
cariole9818343cariole
caritas93316943carita_s
caritases1139743caritases
carjack2246153carjack
carle74535703car__le
carline93923613carline
carmaker1637303carmaker
carman103920743carma_n
carmine112918483carmine
carnal83919203carna_l
carnie84421093car_nie
caroach1488863caroach
caroche1469243caroche
carotene1039133carotene
carouse9614423carouse
carpal103716253carpa_l
carpals113414623carpals
carrack1548753carrack
carrageen1274013carrageen
carriages1238333carriages
carse74934333car__se
cart66570343cart___
carted98631443cart_ed
cartel85022533cart_el
cartels94618123cartels
carter84932273cart_er
carters95327243carters
cartes86239473cart_es
cartilages1345513cartilages
carting104228283carting
carton84522663cart_on
cartoned111312833cartoned
cartons94122473cartons
cartoon94114463cartoon
cartop104213563cart_op
cartridge1372723cartridge
carts78946293cart__s
carve106227753car__ve
carwash1535993carwash
cascade12118603cascade
casease939323casease
caseate9314783caseate
castable121613973castable
castanet10416193castanet
caste75932363cast__e
castle84918963cast_le
castrate10313863castrate
catalo8314853ca_talo
cate66254593ca_t__e
catface1436763catface
cattail939173cattail
cattalo938423cattalo
cattie85221013ca_ttie
cattle85118903ca_ttle
caudate10311353caudate
caviare1238373caviare
cavitate13159833cavitate
centare93113703centare
cerate84829463cer_ate
certain92612213certain
cetane8315283c_etane
chaetae1238603chaeta_e
chantages1546583chantages
charade13129903char_ade
charge125114213char__ge
chartable1636833chartable
cirrate92413483cirrate
citrate92216793citrate
coarctate1344813coarctate
coinage10310553coinage
collage102813753collage
cordages12310113cordages
cordate10315213cordate
corkages1539103corkages
corotate102813933corotate
corrade101111043corrade
corsages11310363corsages
corteges1198813corteges
costae85319683costa_e
costate94019273costate
cottae84615703cotta_e
cottager11306813cottager
cottages113310493cottages
cottagey14305233cottagey
courage10310993courage
cowage12310663c_owage
cowhage1636293cowhage
crag75625303c_r_ag_
crags85622573c_r_ags
crake114823523c_r_ake
crane75331603c_r_ane
crape96128443c_r_ape
crate76537403c_r_ate
crave105626313c_r_ave
craze165221463c_r_aze
crease85519573c_rease
create85126373c_reate
cringe93515483c_ringe
cubage1178273c_ubage
curagh1236553cur_agh
curare84916953cur_are
curate85226243cur_ate
curettage1242353curettage
curiae84518373curia_e
curragh1344293curragh
curtail9299663curtail
curtain9319793curtain
curtal83914543curta_l
curtals93111623curtals
curtilage1243203curtilage
cuttages11297223cuttages
damage10410773da_mage
dartle73714833dart_le
dotage82711613_dotage
drayage1234423drayage
ecarte84313503ecart__e
ecotage1036883ecotage
enrage72715073enr_age
farrago1144923farrago
flotage1136683flotage
footage1148843footage
forage104617003for_age
garaged1039253gar_aged
garages9314113gar_ages
garbages1238183garbages
garbagey1543373garbagey
garbagy1444243garbagy
gavage1137193ga_vage
graftage1343683graftage
hartal9415473harta_l
hartals10313023hartals
hastate10313913hastate
haulage1136913haulage
haylage1436443haylage
herbage1337003herbage
heritage1246533heritage
hostage113111233hostage
karate105320923kar_ate
lactase937953lactase
lactate9312693lactate
large65325463lar__ge
larvae938843larva_e
lavage1038263la_vage
maltase938903maltase
manage93818903ma_nage
marge85328333mar__ge
marriage1147253marriage
martagon1145273martagon
massage1039893massage
meltage1037953meltage
metage93114453_metage
mintage101110123mintage
mirage92313653mir_age
montage101211713montage
mortgage1244213mortgage
narrate7313493narrate
onstage838363onstage
outage72017533_outage
outrage82616893outrage
package16128013package
parade94720643par_ade
parae76335703par_a_e
parbake1538353parbake
parentage1245603parentage
parge85831853par__ge
parkade1437583parkade
partaken1445553partaken
partaker1436873partaker
partakes1449923partakes
partan83820563parta_n
partans94418283partans
partite9317133partite
passage1039803passage
pawnage1335873pawnage
portaged12228463portaged
portages112613223portages
postage103214853postage
potage92715903_potage
pottage103310603pottage
rage55742353__r_age
ragtag836643ragtag_
ragtags935373ragtags
rampage1237453rampage
ravage1039303ra_vage
restage83316183restage
rootage839053rootage
sabotage1144593sabotage
salvage1138193salvage
sarape84817573sar_ape
sarge65531133sar__ge
sausage847193sausage
savage10410173sa_vage
scalage103110533sca_lage
scutage1036333scutage
septage1078403septage
serfage1138403serfage
shortage1236303shortage
stage65330193__stage
tallage82712073tallage
tankage12257773tankage
tannage8209583tannage
targe65227093tar__ge
tartan64217513tarta_n
tartana73010193tartana
tartans72615823tartans
tartar63214753tarta_r
tartars73313403tartars
tartrate899673tartrate
tartufe1064673tartufe
tentage81010643tentage
triage72812893_triage
unitage838993unitage
upstage10167443upstage
vantages12119023vantages
variate101316433variate
ventage11109623ventage
vicarage1444433vicar_age
vintage11128143vintage
voltage1136863voltage
vorlage1136403vorlage
waftages15105393waftages
wantages12109023wantages
warfare1336733warfare
warpages1437053warpages
wartime1237743wartime
wastages12109753wastages
watape11208483wa_tape
wattages12106783wattages
wattape12135383wattape
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.1561145455.1
2DLD Change Limit1340273447.45317983.0
3Display Results3443440.1232796.7
 (SQL Overall)1786913447.73223110.6
 
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.