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

202 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
rootage83905(None) 
footage1148841footage
rootages939101rootages
cottage104210572cottage
dotage82711612_dotage
ecotage1036882ecotage
flotage1136682flotage
footages1239052footages
frontage1296242frontage
frottage1245082frottage
hostage113111232hostage
montage101211712montage
moorage1038742moorage
outage72017532_outage
portage103013642portage
postage103214852postage
potage92715902_potage
pottage103310602pottage
restage83316192restage
rootle63214452root_le
rotate63320342r_otate
voltage1136862voltage
agiotage1043563agiotage
aortae65115473aorta_e
bondage1138253bondage
bootable12179223bootable
bootee84323023boot_ee
bootie85421163boot_ie
bootlace1245403bootlace
bootleg10276633bootleg
borage93917013_borage
boscage1276533boscage
boskage1465413boskage
brockage1744743brockage
brokage1436673brokage
buoyage1344293buoyage
cabotage1345223cabotage
cartage10312593cartage
coinage10310553coinage
collage102813763collage
cootie84223093coot_ie
cordage11310063cordage
corkage1438373corkage
corotate102813933corotate
corsage1039803corsage
cortege1098953cortege
costae85319683costa_e
costate94019273costate
cottae84615703cotta_e
cottager11306813cottager
cottages113310493cottages
cottagey14305233cottagey
courage10310993courage
cowage12310673_cowage
cowhage1636303cowhage
cuttage10318343cuttage
dockage1535723dockage
dosage82810003_dosage
dotages92311793_dotages
driftage1342933driftage
ecotages1136973ecotages
floatage1244403floatage
floorage1275093floorage
flotages1237163flotages
flowage1435723flowage
foggage1334113foggage
foliage1147533foliage
footbag1344553footbag_
footbags1444523footbags
footie94718143foot_ie
footle93914383foot_le
footpace1544493footpace
footrace1346413footrace
footsie1047653footsie
forage104617003_forage
fromage1336753fromage
frontages13116183frontages
frontpage15102633frontpage
frottages1384993frottages
fruitage1244343fruitage
graftage1343683graftage
helotage1245713helotage
homage121210603_homage
hostages122311693hostages
lockage1436613lockage
lovage1037353_lovage
meltage1037953meltage
metage93114453_metage
mintage101110123mintage
montaged12107763montaged
montages111412183montages
montane91313623montane
moorages1139053moorages
mortgage1244213mortgage
moulage1037903moulage
nonage7313683_nonage
nonwage1137163nonwage
noodge8337583noo_dge
notate63217863_notate
octane81411633_octane
octave11157343_octave
ohmage1295063_ohmage
onstage838363onstage
outages82317323_outages
outate62923403_outate
outrage82616893_outrage
peonage1048723peonage
pilotage1145373pilotage
plottage1144433plottage
portaged12228463portaged
portages112613223portages
postages112815323postages
potages102416423_potages
pottages112910453pottages
prophage1649433prophage
prostate10314533prostate
protege1059153protege
rage55742353r___age
ragtag836643ragtag_
ragtags935373ragtags
rampage1237453rampage
ravage1039303r_avage
reimage1037913reimage
reportage1245023reportage
restaged103011863restaged
restages92815773restages
restate73824883restate
retag63618413r_etag_
retags73414303r_etags
retake104718533r_etake
retape83917683r_etape
rivage1038843r_ivage
robotize1945693robotize
rontgen835173ront_gen
roofie93411173roo_fie
rooftree1163353rooftree
rookie103613263roo_kie
roomie83013873roo_mie
roommate1244863roommate
roose56127093roo__se
root45655923root___
rootcap1143973rootcap
rootcaps1243863rootcaps
rooted75424003root_ed
rooter64926033root_er
rooters74522933rooters
rootier74915393rootier
rooting83522433rooting
rootled83410533rootled
rootles73215633rootles
rootlet73015733rootlet
rootlike1236613rootlike
roots55933673root__s
rooty86423023root__y
roseate7613453roseate
rostrate8313843rostrate
rota45834343r_ota__
rotary92411303r_otary
rotas54827723r_ota_s
rotated82715293r_otated
rotates72819773r_otates
rotche114311983r_otche
rote46249023r_ot__e
rotte54625933r_ot_te
rouge65423443r_o_uge
roughage1344423roughage
roulade857003roulade
route55132073rout__e
routine72615903routine
rummage1234583rummage
sabotage1144603sabotage
scutage1036333scutage
septage1078403septage
shortage1236313shortage
soakage1236103soakage
socage91012123_socage
soccage1236283soccage
soilage8169353soilage
soothe94214853soot_he
soutane7312063soutane
stage65330193__stage
storage8310473storage
stowage1136703stowage
tentage81010643tentage
tollage82610163tollage
tonnage8168053tonnage
tootle62613813toot_le
tootsie737133tootsie
towage1039833_towage
unitage838993unitage
upstage10167443upstage
vantage11109893vantage
ventage11109623ventage
vintage11128143vintage
voltages1237253voltages
vorlage1136403vorlage
voyage1335473_voyage
waftage14115323waftage
wantage11119623wantage
wastage11109253wastage
wattage1186983wattage
wordage1236503wordage

Search took 7 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.406440125.6
2DLD Change Limit1340272026.01622278.4
3Display Results2022020.0762657.9
 (SQL Overall)1786912026.49827499.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.