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

104 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
shortages133651(None) 
shortage1236311shortage_
hostages122311692_hostages
portages112613222_portages
shortcakes1943022shortcakes
shorties11414582short_ies
shortwaves1942562shortwaves
storages9311102stor_ages
borages103917163_bor_ages
cartages11313313_cartages
chantages1546583chantages
choragus1474303chor_agus
chorales133712883chor_ales
chordates1547683chordates
chortles133611323chort_les
cordages12310113_cordages
corkages1539103_corkages
corsages11310363_corsages
corteges1198823_corteges
cottages113310493_cottages
dotages92311793_do_tages
ecotages1136973eco_tages
floatages1344233floatages
flotages1237163flo_tages
footages1239053_footages
forages114217283_for_ages
frontages13116183frontages
frottages1384993frottages
herbages1437093_herbages
heritages1346713_heritages
homages131011583_ho_mages
hostage113111233_hostage_
montages111412183_montages
moorages1139053moor_ages
mortgages1344023_mortgages
outages82317323__outages
phorates13413043phor_ates
plottages1244243plottages
portage103013643_portage_
portaged12228463_portaged
postages112815323_postages
potages102416423_po_tages
pottages112910453_pottages
reportages1344383reportages
rootages939103_rootages
sabotages1244433sabotages
scutages1136503s_cutages
septages1168263s_eptages
serfages1238233s_erfages
shiitakes1643013shiitakes
shitakes1546113sh_itakes
shoelaces1445233shoelaces
shoetrees1244353shoetrees
shoptalks1842673shoptalks
shorans102812413shor_a_ns
shores94830413shor___es
shorings12269483shoring_s
shortcake1843203shortcake_
shortchanges2151623shortchanges
shortcuts1442513shortcuts
shorted113614403short__ed
shorten103511413short__en
shortened1345663shortened
shortener1245773shortener
shorteners1345083shorteners
shortens11288993short_ens
shorter103515503short__er
shortest11310783short__est
shortfalls1652913shortfalls
shorthairs1672813shorthairs
shorthands1743493shorthands
shortias1148093short_ias
shortie10411343short_ie_
shortness1236733shortness
shorts95321743short___s
shortwave1842483shortwave_
shortwaved2051803shortwaved
shotes95321913sho_t__es
showcases1743323showcases
showtimes1743653showtimes
soakages1336143s_oakages
socages101012053s_o_cages
soccages1336383s_occages
soilages9189673s_oilages
sorbates10311103s_orbates
sorties74126403s_ort_ies
soutanes8312933s_outanes
spoilages12184713spoilages
stages75629493s___tages
stockages1644923stockages
stoppages1444693stoppages
storage8310473stor_age_
storaxes1536883stor_axes
stowages1236473sto_wages
substages12127353substages
surtaxes1536513s_urtaxes
thirlages1343763thirlages
thoraces13118943thor_aces
thoraxes1896363thor_axes
voltages1237253_voltages
vorlages1236033_vorlages
wharfages1942633wharfages
whortles14306743whort_les
wordages1337053_wordages

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 Filter1786911486410.406440125.6
2DLD Change Limit1486411046.37323323.6
3Display Results1041040.0462260.9
 (SQL Overall)1786911046.82526181.8
 
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.