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

206 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
footages123905(None) 
flotages1237161flotages
footage1148841footage_
rootages939101rootages
cottages113310492cottages
dotages92311792_dotages
ecotages1136972ecotages
floatages1344232floatages
floorages1364982floorages
flotage1136682flotage_
flowages1535732flowages
foggages1434212foggages
foliages1247622foliages
footbags1444522footbag_s
footies103721542foot_ies
footles103715712foot_les
footpaces1644642footpaces
footraces1446712footraces
footsies1139642footsies
forages114217282f_orages
fromages1437072fromages
frontages13116182frontages
frottages1384992frottages
hostages122311692hostages
montages111412182montages
moorages1139052moorages
outages82317322_outages
portages112613222portages
postages112815322postages
potages102416422_potages
pottages112910452pottages
rootage839052rootage_
voltages1237252voltages
agiotages1143773agiotages
bondages1237893bondages
bootees94114473boot_ees
booties94124613boot_ies
bootlaces1345033bootlaces
bootlegs11325873bootlegs
borages103917163_borages
boscages1366643boscages
boskages1565423boskages
brokages1536253brokages
buoyages1443803buoyages
cabotages1444853cabotages
cartages11313313cartages
coinages11310803coinages
collages113514243collages
cooties93725733coot_ies
cordages12310113cordages
corkages1539103corkages
corotates112714283corotates
corsages11310363corsages
corteges1198823corteges
cottage104210573cottage_
cottager11306813cottager
cottagers12305383cottagers
cottagey14305233cottagey
courages11311393courages
cowages13310943_cowages
cowhages1736113cowhages
cuttages11297223cuttages
dockages1635983dockages
dosages92310803_dosages
dotage82711613_dotage_
ecotage1036883ecotage_
floatage1244403floatage_
floorage1275093floorage_
flotas94013003flota__s
flowage1435723flowage_
foetuses1136083foetuses
foggage1334113foggage_
folates103218453f_olates
foliage1147533foliage_
foliaged1344673foliaged
foliates11412753foliates
folktales1653123folktales
fontanel1145553fontanel
fontanels1244063fontanels
foodies113416753foo_dies
footbag1344553footbag__
footballs1445363footballs
footbaths1763093footbaths
footboys1644333footboys
footed104418623foot__ed
footer94320773foot__er
footers104618333foot_ers
footfalls1544593footfalls
footgear12113063foot_gear
footgears13103073foot_gears
footie94718143foot_ie_
footier104115113foot_ier
footiest113514913foot_iest
footings12248833footings
footle93914383foot_le_
footled113610763foot_led
footler104011873foot_ler
footlers113910793footlers
footless113710803footless
footmarks1843583footmarks
footmen1246583foot_men
footnotes1244323footnotes
footpace1544493footpace_
footpads1443983footpads
footpaths1762993footpaths
footrace1346413footrace_
footrest11308853foot_rest
footropes1446413footropes
foots85528283foot___s
footsie1047653footsie_
footstep1363823footstep
footsteps1462863footsteps
footwalls1544383footwalls
footways1744873footways
foozles19329543foo_zles
forage104617003f_orage_
foraged124812283f_oraged
forager114412563f_orager
foragers12349633f_oragers
forestages1446733forestages
forges105024263f_o_rges
formates132814293formates
forsakes1536893forsakes
fortes95327183fort__es
forties104323863fort_ies
fortunes1158283fortunes
fosterages1444773fosterages
foxtails1844583foxtails
fromage1336753fromage_
frontage1296243frontage_
frontpages1692643frontpages
frottage1245083frottage_
fruitages1344483fruitages
geotaxes1644743geotaxes
helotages1346123helotages
homages131011583_homages
homotaxes2145743homotaxes
hootches1656973hootches
hostage113111233hostage_
lockages1536723lockages
lovages1138033_lovages
meltages1148243meltages
metages102714973_metages
mintages111110513mintages
montage101211713montage_
montaged12107763montaged
montanes101114523montanes
moorage1038743moorage_
mortgages1344023mortgages
moulages1138053moulages
nonages8313843_nonages
nontaxes1537853nontaxes
noodges9317713noo_dges
notates72817483_notates
octanes91111393_octanes
octaves12316963_octaves
offstages1652033offstages
ohmages13115093_ohmages
outage72017533_outage_
outrages92215933_outrages
peonages1138473peonages
pilotages1245503pilotages
plottages1244243plottages
portage103013643portage_
portaged12228463portaged
postage103214853postage_
potage92715903_potage_
pottage103310603pottage_
protases102115033protases
proteges1149923proteges
restages92815773restages
rootles73215633root_les
rotates72819773_rotates
sabotages1244433sabotages
scutages1136503scutages
septages1168263septages
shortages1336513shortages
soakages1336143soakages
socages101012053_socages
soccages1336383soccages
soilages9189673soilages
soothes103917113soot_hes
soutanes8312933soutanes
stages75629493__stages
storages9311103storages
stowages1236473stowages
tentages91011043tentages
tollages92410193tollages
tonnages9187873tonnages
tootles72915603toot_les
tootses72910773toot_ses
tootsies848613tootsies
towages1139233_towages
unitages938273unitages
upstages11147373upstages
vantages12119023vantages
ventages12119773ventages
vintages12118273vintages
voltage1136863voltage_
vorlages1236033vorlages
voyages1435703_voyages
waftages15105393waftages
wantages12109023wantages
wastages12109753wastages
wattages12106783wattages
wordages1337053wordages

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.436409841.7
2DLD Change Limit1461622066.59622159.2
3Display Results2062060.0762710.5
 (SQL Overall)1786912067.10825139.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.