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

111 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
shortage123631(None) 
shortages1336511shortages
hostage113111232_hostage
portage103013642_portage
shortcake1843202shortcake
shortie10411342short_ie
shortwave1842482shortwave
storage8310472stor_age
aortae65115473_aorta_e
borage93917013_bor_age
cartage10312593_cartage
chantage1446633chantage
choragi1346683chor_agi
chorale124313353chor_ale
chordate1448033chordate
chortle124210443chort_le
cordage11310063_cordage
corkage1438373_corkage
corsage1039803_corsage
cortege1098953_cortege
cottage104210573_cottage
dotage82711613_do_tage
ecotage1036883eco_tage
floatage1244403floatage
flotage1136683flo_tage
footage1148843_footage
forage104617003_for_age
frontage1296243frontage
frottage1245083frottage
herbage1337003_herbage
heritage1246533_heritage
homage121210603_ho_mage
hostages122311693_hostages
montage101211713_montage
moorage1038743moor_age
mortgage1244213_mortgage
outage72017533__outage
phorate12413363phor_ate
plottage1144433plottage
portaged12228463_portaged
portages112613223_portages
postage103214853_postage
potage92715903_po_tage
pottage103310603_pottage
reportage1245023reportage
rootage839053_rootage
sabotage1144603sabotage
scoriae9310903scoria_e
scutage1036333s_cutage
septage1078403s_eptage
serfage1138403s_erfage
shiitake1542883shiitake
shitake1455623sh_itake
shoelace1345293shoelace
shoetree1146573shoetree
shoptalk1743573shoptalk
shoran94016043shor_a_n
shorans102812413shor_ans
shore85432653shor___e
shoring112820073shoring_
shorings12269483shorings
short85040533short___
shortcakes1943023shortcakes
shortchange2051693shortchange
shortcut1344453shortcut
shorted113614403short_ed
shorten103511413short_en
shortened1345663shortened
shortener1245773shortener
shortens11288993shortens
shorter103515503short_er
shortest11310783shortest
shortfall1542873shortfall
shorthair1543023shorthair
shorthand1643753shorthand
shortia1048193short_ia
shortias1148093shortias
shorties11414583shorties
shorting122514803shorting
shortish1437423shortish
shortly13387573short_ly
shorts95321743short__s
shortwaved2051803shortwaved
shortwaves1942563shortwaves
shorty124313203short__y
shote85526103sho_t__e
showcase1643123showcase
showtime1643773showtime
soakage1236103s_oakage
socage91012123s_o_cage
soccage1236283s_occage
soilage8169353s_oilage
sorbate9311733s_orbate
sorta57125413s_orta__
sortable10312483s_ortable
sortie63621993s_ort_ie
soutane7312063s_outane
spoilage11195373spoilage
sportive1348333sportive
stage65330193s___tage
stockage1544903stockage
stoppage1344683stoppage
storages9311103stor_ages
stowage1136703sto_wage
substage11117183substage
thirlage1243823thirlage
voltage1136863_voltage
vorlage1136403_vorlage
wharfage1842213wharfage
whortle13335943whort_le
wordage1236503_wordage

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.420425454.8
2DLD Change Limit1461621116.59322169.3
3Display Results1111110.0333363.6
 (SQL Overall)1786911117.04625360.6
 
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.