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

155 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
wordage123650(None) 
cordage11310061cordage
wordages1337051wordages
bondage1138252bondage
borage93917012bor_age
cordages12310112cordages
cordate10315222cordate
corkage1438372corkage
corsage1039802corsage
forage104617002for_age
portage103013642portage
vorlage1136402vorlage
warpage1336402warpage
windage1237932windage
wodge107212932wo_d_ge
yardage1235732yardage
acreage1037843acreage
adage7414053__adage
airdate8311323airdate
aortae65115473aorta_e
bandage11311023bandage
barrage10710843barrage
birdcage1443513birdcage
bondages1237893bondages
borages103917163bor_ages
borane84620213bor_ane
borate85026153bor_ate
bordure1035783bordure
boscage1276533boscage
boskage1465413boskage
brokage1436673brokage
burgage1136633burgage
carnage10311743carnage
cartage10312593cartage
chordate1448033chordate
coinage10310553coinage
collage102813763collage
cordite10315263cordite
corkages1539103corkages
corrade101111043corrade
corsages11310363corsages
cortege1098953cortege
cottage104210573cottage
courage10310993courage
cowage12310673co_wage
cowhage1636303cowhage
dockage1535723dockage
dodge86618133do_d_ge
dosage82810003do_sage
dotage82711613do_tage
enrage72715073enr_age
foggage1334113foggage
foliage1147533foliage
footage1148843footage
foraged124812283for_aged
forager114412563for_ager
forages114217283for_ages
forbade13259103forbade
forbare122310513forbare
fordable1439593fordable
fordone1149383fordone
foredate12310913foredate
forgave1435853forgave
forge95126943for__ge
formate123115093formate
forsake1436533forsake
fromage1336753fromage
garage8314513gar_age
garbage1138053garbage
gorge76423893gor__ge
herbage1337003herbage
homage121210603ho_mage
horde94623053hord__e
hostage113111233hostage
iodate7313503io_date
jordan1468063jorda_n
jordans1566833jordans
lockage1436613lockage
lodge76520093lo_d_ge
lovage1037353lo_vage
lurdane835983lurdane
mirage92313653mir_age
montage101211713montage
moorage1038743moorage
morae75831193mor_a_e
morale85220553mor_ale
mordant10312403mordant
mortgage1244213mortgage
moulage1037903moulage
nonage7313683no_nage
nonwage1137163nonwage
noodge8337583nood_ge
ohmage1295063_ohmage
orange74016323_orange
orate55133303_or_ate
ordain7810403_ordain
ordure756813_ordure
ornate6315143_ornate
outage72017533_outage
portaged12228463portaged
portages112613223portages
postage103214853postage
potage92715903po_tage
pottage103310603pottage
poundage1244023poundage
rage55742353__r_age
rootage839053rootage
serfage1138403serfage
shortage1236313shortage
soakage1236103soakage
socage91012123so_cage
soccage1236283soccage
soilage8169353soilage
sorbate9311733sorbate
sordine82515233sordine
storage8310473stor_age
tollage82610163tollage
tonnage8168053tonnage
torsade837593torsade
towage1039833to_wage
triage72812893_triage
voltage1136863voltage
vorlages1236033vorlages
voyage1335473vo_yage
waftage14115323waftage
wage84834083w___age
wantage11119623wantage
warfare1336733warfare
warpages1437053warpages
wastage11109253wastage
wattage1186983wattage
webpage1543133webpage
wedge105215663w_ed_ge
wharfage1842213wharfage
windages1338263windages
wodges117413683wo_d_ges
woodie103513613wood_ie
word89832003word___
worded114316623word_ed
wordier112511213wordier
wordily1437853wordily
wording123014563wording
wordings13328563wordings
words95425073word__s
wordy126916163word__y
wore77144673wor___e
workable1737093workable
workbag1742923workbag_
workbags1843013workbags
workday1843303workda_y
workdays1942903workdays
workfare1843123workfare
workmate1744673workmate
worse86525263wor__se
yardages1336203yardages

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.393454684.5
2DLD Change Limit1340271557.14018771.3
3Display Results1551550.0463369.6
 (SQL Overall)1786911557.57923577.1
 
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.