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

199 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
rootages93909(None) 
footages1239041footages
rootage839041rootage_
cottages113310492cottages
dotages92311792_dotages
ecotages1136972ecotages
flotages1237152flotages
footage1148832footage_
frontages13116182frontages
frottages1384982frottages
hostages122311692hostages
montages111412182montages
moorages1139042moorages
outages82317322_outages
portages112613222portages
postages112815322postages
potages102416422_potages
pottages112910452pottages
restages92815762restages
rootles73215632root_les
rotates72819772r_otates
voltages1237252voltages
agiotages1143773agiotages
bondages1237893bondages
bootees94114473boot_ees
booties94124613boot_ies
bootlaces1345033bootlaces
bootlegs11325873bootlegs
borages103917163_borages
boscages1366643boscages
boskages1565423boskages
brockages1844783brockages
brokages1536253brokages
buoyages1443803buoyages
cabotages1444853cabotages
cartages11313313cartages
coinages11310803coinages
collages113514233collages
cooties93725733coot_ies
cordages12310113cordages
corkages1539103corkages
corotates112714283corotates
corsages11310363corsages
corteges1198813corteges
cottage104210573cottage_
cottager11306803cottager
cottagers12305373cottagers
cottagey14305233cottagey
courages11311393courages
cowages13310933_cowages
cowhages1736103cowhages
cuttages11297223cuttages
dockages1635983dockages
dosages92310803_dosages
dotage82711613_dotage_
driftages1453153driftages
ecotage1036883ecotage_
floatages1344233floatages
floorages1364973floorages
flotage1136673flotage_
flowages1535733flowages
foggages1434213foggages
foliages1247623foliages
footbags1444513footbag_s
footies103721543foot_ies
footles103715713foot_les
footpaces1644633footpaces
footraces1446703footraces
footsies1139643footsies
forages114217273_forages
fromages1437073fromages
frontage1296243frontage_
frontpages1692643frontpages
frottage1245073frottage_
fruitages1344483fruitages
geotaxes1644743geotaxes
graftages1443683graftages
helotages1346123helotages
homages131011583_homages
homotaxes2145743homotaxes
hootches1656973hootches
hostage113111233hostage_
lockages1536723lockages
lovages1138033_lovages
meltages1148243meltages
metages102714973_metages
mintages111110513mintages
montage101211713montage_
montaged12107763montaged
montanes101114523montanes
moorage1038733moorage_
mortgages1344023mortgages
moulages1138053moulages
nonages8313843_nonages
nontaxes1537853nontaxes
noodges9317703noo_dges
notates72817483_notates
octanes91111393_octanes
octaves12316963_octaves
ohmages13115093_ohmages
outage72017533_outage_
outrages92215923_outrages
peonages1138473peonages
pilotages1245503pilotages
plottages1244243plottages
portage103013643portage_
portaged12228463portaged
postage103214853postage_
potage92715903_potage_
pottage103310603pottage_
prophages1749763prophages
prostates11314423prostates
protases102115033protases
proteges1149923proteges
rages64539443r___ages
ragtags935373ragtag_s
rampages1336673rampages
ravages1139403r_avages
reimages1138373reimages
reportages1344383reportages
restage83316183restage_
restaged103011853restaged
restates83423413restates
retags73414303r_etag_s
retakes113718863r_etakes
retapes93917423r_etapes
retaxes143615093r_etaxes
rheotaxes1943573rheotaxes
rivages1138873r_ivages
robotizes2045753robotizes
robotries1147323robotries
rontgen835173ront_gen
rontgens944683ront_gens
roofies103014413roo_fies
rooftrees1242403rooftrees
rookies113917103roo_kies
roomies93017243roo_mies
roommates1344843roommates
rooses65526233roo__ses
rootcaps1243863rootcaps
rooted75424003root__ed
rooter64926033root__er
rooters74522933root_ers
rootier74915393root_ier
rootiest83115593root_iest
rootiness979063rootiness
rootle63214453root_le_
rootled83410533root_led
rootless83910443rootless
rootlet73015733root_let
rootlets8308653rootlets
roots55933673root___s
rotaries8315693r_otaries
rotas54827723r_ota__s
rotate63320343r_otate_
rotated82715293r_otated
rotches123515703r_otches
rotes56143903r_ot__es
rottes64524833r_ot_tes
rouges76022383r_o_uges
roughages1444383roughages
roulades957163roulades
routes66129313rout__es
routines82214363routines
rummages1344933rummages
sabotages1244433sabotages
scutages1136503scutages
septages1168263septages
shortages1336513shortages
soakages1336143soakages
socages101012053_socages
soccages1336383soccages
soilages9189673soilages
soothes103917103soot_hes
soutanes8312933soutanes
stages75629493__stages
storages9311103storages
stowages1236473stowages
tentages91011043tentages
tollages92410193tollages
tonnages9187873tonnages
tootles72915603toot_les
tootses72910773toot_ses
tootsies848613tootsies
towages1139233_towages
tropotaxes1953833tropotaxes
unitages938273unitages
upstages11147373upstages
vantages12119023vantages
ventages12119763ventages
vintages12118273vintages
voltage1136863voltage_
vorlages1236033vorlages
voyages1435703_voyages
waftages15105393waftages
wantages12109023wantages
wastages12109753wastages
wattages12106783wattages
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.1561145455.1
2DLD Change Limit1461621998.01618233.8
3Display Results1991990.0762618.4
 (SQL Overall)1786911998.24821664.8
 
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.