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

209 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
cottages11331049(None) 
cottage104210571cottage_
cottager11306811cottager
cottagers12305381cottagers
cottagey14305231cottagey
cuttages11297221cuttages
pottages112910451pottages
cartages11313312cartages
coinages11310802coinages
collages113514242collages
cordages12310112cordages
corkages1539102corkages
corsages11310362corsages
corteges1198822corteges
cottae84615702cotta_e_
cottars94412242cotta_rs
cottas84615572cotta__s
courages11311392courages
cowages13310942co_wages
cowhages1736112cowhages
cuttage10318342cuttage_
dotages92311792do_tages
ecotages1136972eco_tages
footages1239052footages
frottages1384992frottages
hostages122311692hostages
montages111412182montages
outages82317322_outages
plottages1244242plottages
portages112613222portages
postages112815322postages
potages102416422po_tages
pottage103310602pottage_
rootages939102rootages
voltages1237252voltages
wattages12106782wattages
bondages1237893bondages
borages103917163bo_rages
boscages1366643boscages
boskages1565423boskages
bottles94216273bott_les
cabbages1537203cabbages
cabotages1444853cabotages
cages85936013c___ages
carnages11312213carnages
cartage10312593cartage_
catfaces1536963catfaces
cattails1038553cattails
cattaloes1146183cattaloes
cattalos1037933cattalos
catties94023053catt_ies
centares102913893centares
cetanes9315133c_etanes
chantages1546583chantages
citrates102315093citrates
coatees93816553coat_ees
coattails1144853coattails
coaxes154715633co__axes
coccyges1542333coccyges
cockades1738433cockades
cogitates1247863cogitates
cognates11311583cognates
coinage10310553coinage_
coituses1039623coituses
collage102813763collage_
collaged12279973collaged
collagen11338573collagen
collagens12256033collagens
collates103019143collates
colleges112410523colleges
comakes154413643co_makes
comanages1446533comanages
comates114123643co_mates
compares143816433compares
comrades13149773comrades
comtes106222813comt__es
concaves1538913concaves
conges94928173co__nges
contacts123215213contacts
contagia1156773contagia
contains10316533contains
contes84432913cont__es
contuses10413453contuses
cooties93725733coot_ies
cordage11310063cordage_
corkage1438373corkage_
corotates112714283corotates
corrades111211263corrades
corsage1039803corsage_
cortege1098953cortege_
cortexes1797613cortexes
cortices12615013cortices
costae85319683costa_e_
costards113510793costards
costars94218013costa_rs
costate94019273costate_
costumes1258013costumes
cotans81317923co_ta_ns
coteries10422703coteries
cotes76347843co_t__es
cotingas11316323cotingas
cotta75818573cotta___
cottar84613813cotta__r
cotter84926673cott__er
cottered112511733cottered
cotters94323443cott_ers
cottier93814173cott_ier
cottiers10399153cottiers
cottoned1138033cottoned
cottons9312193cott_ons
cotypes1437943co_types
courage10310993courage_
coutures10311993coutures
couvades1435613couvades
coverages1538833coverages
cowage12310673co_wage_
cowbanes1537423cowbanes
cowhage1636303cowhage_
cozenages2194693cozenages
cubages1237923c_ubages
curettages1342353curettages
cutlases1038033cutlases
cutties93118843cutt_ies
cuttles93613923cutt_les
dockages1635983dockages
dosages92310803do_sages
dotage82711613do_tage_
dottles83912283dott_les
ecotage1036883eco_tage_
floatages1344233floatages
flotages1237163flotages
foggages1434213foggages
foliages1247623foliages
footage1148843footage_
forages114217283fo_rages
frontages13116183frontages
frottage1245083frottage_
homages131011583ho_mages
hostage113111233hostage_
hotcakes1744703hotcakes
hotties103016963hott_ies
lockages1536723lockages
lottes65322753lott__es
lovages1138033lo_vages
meltages1148243meltages
metages102714973_metages
mintages111110513mintages
montage101211713montage_
montaged12107763montaged
montanes101114523montanes
moorages1139053moorages
mortgages1344023mortgages
mottes85523693mott__es
mottles93415803mott_les
mottoes93412193mott_oes
moulages1138053moulages
nonages8313843no_nages
nontaxes1537853nontaxes
notates72817483no_tates
octanes91111393_octanes
octaves12316963_octaves
ohmages13115093_ohmages
ottars64112223_otta_rs
ottavas1093483_ottavas
outage72017533_outage_
outrages92215933outrages
outtakes12310033outtakes
plottage1144433plottage_
portage103013643portage_
portaged12228463portaged
postage103214853postage_
potage92715903po_tage_
potatoes1039943potatoes
potties93723543pott_ies
pottles93816983pott_les
restages92815773restages
rootage839053rootage_
rotates72819773ro_tates
rottes64524833rott__es
scotties1039753scott_ies
scutages1136503scutages
septages1168263septages
shortages1336513shortages
soakages1336143soakages
socages101012053so_cages
soccages1336383soccages
soilages9189673soilages
soutanes8312933soutanes
stages75629493__stages
storages9311103storages
stowages1236473stowages
tentages91011043tentages
tollages92410193tollages
tonnages9187873tonnages
towages1139233to_wages
unitages938273unitages
upstages11147373upstages
vantages12119023vantages
ventages12119773ventages
vintages12118273vintages
voltage1136863voltage_
vorlages1236033vorlages
voyages1435703vo_yages
waftages15105393waftages
wantages12109023wantages
wastages12109753wastages
wattage1186983wattage_
wattapes1395253wattapes
wordages1337053wordages

Search took 9 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.436409841.7
2DLD Change Limit1461622097.93618417.6
3Display Results2092090.0932247.3
 (SQL Overall)1786912098.46521109.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.