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

217 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
footage114883(None) 
flotage1136671flotage
footages1239041footages
rootage839041rootage
cottage104210572cottage
dotage82711612_dotage
ecotage1036882ecotage
floatage1244402floatage
floorage1275082floorage
flotages1237152flotages
flowage1435722flowage
foggage1334112foggage
foliage1147532foliage
footbag1344542footbag_
footbags1444512footbags
footie94718132foot_ie
footle93914382foot_le
footpace1544482footpace
footrace1346402footrace
footsie1047642footsie
forage104616992f_orage
fromage1336752fromage
frontage1296242frontage
frottage1245072frottage
hostage113111232hostage
montage101211712montage
moorage1038732moorage
outage72017532_outage
portage103013642portage
postage103214852postage
potage92715902_potage
pottage103310602pottage
rootages939092rootages
voltage1136862voltage
agiotage1043563agiotage
aortae65115473aorta_e
bondage1138253bondage
bootable12179223bootable
bootee84323023boot_ee
bootie85421153boot_ie
bootlace1245403bootlace
bootleg10276633bootleg
borage93917013_borage
boscage1276533boscage
boskage1465413boskage
brokage1436673brokage
buoyage1344293buoyage
cabotage1345223cabotage
cartage10312593cartage
coinage10310553coinage
collage102813753collage
cootie84223073coot_ie
cordage11310063cordage
corkage1438373corkage
corotate102813933corotate
corsage1039803corsage
cortege1098943cortege
costae85319683costa_e
costate94019273costate
cottae84615703cotta_e
cottager11306803cottager
cottages113310493cottages
cottagey14305233cottagey
courage10310993courage
cowage12310663_cowage
cowhage1636293cowhage
cuttage10318343cuttage
dockage1535723dockage
dosage82810003_dosage
dotages92311793_dotages
ecotages1136973ecotages
floatages1344233floatages
floorages1364973floorages
florae94713883flora_e
flota85315643flota__
flotas94013003flota_s
flowages1535733flowages
foetal9311883foeta_l
foggages1434213foggages
folate93320393f_olate
foliaged1344673foliaged
foliages1247623foliages
foliate10513533foliate
folktale1542873folktale
fontal9313143fonta_l
fontanel1145553fontanel
foodie104413843foo_die
foot76248013foot___
football1345613football
footbath1664013footbath
footboy1544913footboy
footed104418623foot_ed
footer94320763foot_er
footers104618333footers
footfall1444823footfall
footgear12113053foot_gear
footier104115103footier
footies103721543footies
footing115017593footing
footings12248833footings
footled113610763footled
footler104011863footler
footles103715713footles
footlike1537253footlike
footman1236403footman
footmark1743833footmark
footmen1246583footmen
footnote1144933footnote
footpaces1644633footpaces
footpad1343903footpad
footpads1443983footpads
footpath1663843footpath
footraces1446703footraces
footrope1346243footrope
foots85528283foot__s
footsies1139643footsies
footsore1146063footsore
footstep1363823footstep
footsy12587933foot_sy
footwall1444523footwall
footway1635253footway
footways1744873footways
footy115820533foot__y
foozle18369203foo_zle
foraged124812273f_oraged
forager114412553f_orager
forages114217273f_orages
forbade13259103forbade
forbare122310513forbare
forestage1346973forestage
forgave1435853forgave
forge95126943f_o_rge
formate123115093formate
forsake1436533forsake
forte86131463fort__e
fortune1068303fortune
fossae95510373fossa_e
fossate10388603fossate
fosterage1344653fosterage
foveae1237563fovea_e
foveate1338363foveate
foxtail1745383foxtail
fromages1437073fromages
frontages13116183frontages
frontpage15102633frontpage
frottages1384983frottages
fruitage1244343fruitage
helotage1245713helotage
homage121210603_homage
hostages122311693hostages
lockage1436613lockage
lovage1037353_lovage
meltage1037953meltage
metage93114453_metage
mintage101110123mintage
montaged12107763montaged
montages111412183montages
montane91313623montane
moorages1139043moorages
mortgage1244213mortgage
moulage1037903moulage
nonage7313683_nonage
nonwage1137163nonwage
noodge8337573noo_dge
notate63217863_notate
octane81411633_octane
octave11157343_octave
offstage1541903offstage
ohmage1295063_ohmage
onstage838363onstage
outages82317323_outages
outate62923403_outate
outrage82616883_outrage
peonage1048723peonage
pilotage1145373pilotage
plottage1144433plottage
portaged12228463portaged
portages112613223portages
postages112815323postages
potages102416423_potages
pottages112910453pottages
protege1059153protege
restage83316183restage
rootle63214453root_le
rotate63320343_rotate
sabotage1144593sabotage
scutage1036333scutage
septage1078403septage
shortage1236303shortage
soakage1236103soakage
socage91012123_socage
soccage1236283soccage
soilage8169353soilage
soothe94214843soot_he
soutane7312063soutane
stage65330193__stage
storage8310473storage
stowage1136703stowage
tentage81010643tentage
tollage82610163tollage
tonnage8168053tonnage
tootle62613813toot_le
tootsie737123tootsie
towage1039833_towage
unitage838993unitage
upstage10167443upstage
vantage11109893vantage
ventage11109623ventage
vintage11128143vintage
voltages1237253voltages
vorlage1136403vorlage
voyage1335473_voyage
waftage14115323waftage
wantage11119623wantage
wastage11109253wastage
wattage1186983wattage
wordage1236503wordage

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 Limit1340272176.90619407.3
3Display Results2172170.0802712.5
 (SQL Overall)1786912177.14225019.7
 
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.