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

220 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
hostages12231169(None) 
hostage113111231hostage_
postages112815321postages
boscages1366642boscages
boskages1565422boskages
cottages113310492cottages
dosages92310802dos_ages
dotages92311792do_tages
footages1239052footages
homages131011582ho_mages
hostas94515822hosta__s
hostiles11312212hostiles
montages111412182montages
outages82317322_outages
portages112613222portages
postage103214852postage_
potages102416422po_tages
pottages112910452pottages
restages92815772restages
rootages939102rootages
shortages1336512shortages
stages75629492__stages
upstages11147372upstages
voltages1237252voltages
wastages12109752wastages
apostates1149163apostates
assuages936273assuages
asswages1255053asswages
bondages1237893bondages
borages103917163bo_rages
boscage1276533boscage_
boskage1465413boskage_
cartages11313313cartages
chantages1546583chantages
coinages11310803coinages
collages113514243collages
cordages12310113cordages
corkages1539103corkages
corsages11310363corsages
corteges1198823corteges
costae85319683costa_e_
costards113510793costards
costars94218013costa_rs
costate94019273costate_
costumes1258013costumes
cottage104210573cottage_
cottager11306813cottager
cottagers12305383cottagers
cottagey14305233cottagey
courages11311393courages
cowages13310943co_wages
cowhages1736113cowhages
cuttages11297223cuttages
distaves12311403distaves
dockages1635983dockages
dosage82810003dos_age_
dotage82711613do_tage_
downstages1543293downstages
ecotages1136973ecotages
estates74520183_estates
floatages1344233floatages
flotages1237163flotages
foggages1434213foggages
foliages1247623foliages
footage1148843footage_
forages114217283fo_rages
forestages1446733forestages
fosterages1444773fosterages
frontages13116183frontages
frottages1384993frottages
gestates93213733gestates
hastate10313913hastate_
hastes95727073hast__es
haulages1236623haulages
haylages1536013haylages
hectares1338853hectares
hektares1535813hektares
helotages1346123helotages
hemostases1545493hemostases
heptanes1339003heptanes
herbages1437093herbages
heritages1346713heritages
hesitates1269793hesitates
histogen1245563histogen
histogens1344653histogens
histones11312803histones
hoagies112811993ho__agies
hoaxes163611693ho__axes
hoecakes1745323hoecakes
hogmanes1446783hogmanes
hogties112813993hogt_ies
homage121210603ho_mage_
homaged1497413ho_maged
homager13107853ho_mager
homagers1486823ho_magers
homepages1745223homepages
homotaxes2145743homotaxes
hootches1656973hootches
horstes104516113horst__es
hoses85443173hos___es
hospices1587633hospices
hosta85917833hosta___
hosted105020343host__ed
hostel93914153host__el
hosteled1237283hosteled
hosteler1137273hosteler
hostelers1246633hostelers
hostels103712313host_els
hostess103210243host_ess
hostesses1247173hostesses
hostile10312553hostile_
hostler103411023host_ler
hostlers113310483hostlers
hosts85526703host___s
hotcakes1744703hotcakes
hotches153814363ho_tches
hotties103016963ho_tties
hustles103414173hust_les
hypostases1846103hypostases
instates81615833instates
jostles143411143jost_les
lockages1536723lockages
lovages1138033lo_vages
massages1159883massages
meltages1148243meltages
messages1138233messages
metages102714973_metages
mintages111110513mintages
mispages13311183mispages
mistakes141213413mistakes
montage101211713montage_
montaged12107763montaged
montanes101114523montanes
moorages1139053moorages
mortgages1344023mortgages
moulages1138053moulages
nonages8313843no_nages
nontaxes1537853nontaxes
notates72817483no_tates
octanes91111393_octanes
octaves12316963_octaves
offstages1652033offstages
ohmages13115093_ohmages
onstage838363onstage_
ostoses71213553_ostoses
outage72017533_outage_
outrages92215933_outrages
passages1139513passages
plottages1244243plottages
portage103013643portage_
portaged12228463portaged
postals93716373posta_ls
postbags1345293postbag_s
postdates1248863postdates
postfaces1656273postfaces
posties93128813post_ies
postures10313783postures
potage92715903po_tage_
pottage103310603pottage_
prostates11314423prostates
restage83316193restage_
restaged103011863restaged
restates83423433restates
rootage839053rootage_
rotates72819773ro_tates
sages65339063__s_ages
scutages1136503scutages
septages1168263septages
shortage1236313shortage_
soakages1336143soakages
socages101012053so_cages
soccages1336383soccages
soilages9189673soilages
soutanes8312933soutanes
stades74626243__stades
stage65330193__stage_
staged84521563__staged
stager74821343__stager
stagers84116673__stagers
stagey105915583__stagey
stags66226743__stag_s
stakes103927293__stakes
stales65538293__stales
stanes64933403__stanes
stapes85028733__stapes
stares66038753__stares
stases64225563__stases
states64337083__states
staves94525193__staves
substages12127353substages
swages104417073__swages
tentages91011043tentages
testates83615453testates
tollages92410193tollages
tonnages9187873tonnages
tostadas994523tostadas
tostados995073tostados
towages1139233to_wages
unitages938273unitages
unstates81314993unstates
upstage10167443upstage_
upstaged12135243upstaged
upstager11164633upstager
upstagers12173333upstagers
upstares10178583upstares
upstates10189643upstates
usages759603_us_ages
vantages12119023vantages
ventages12119773ventages
vestiges1238243vestiges
vintages12118273vintages
visages1138693vis_ages
voltage1136863voltage_
vorlages1236033vorlages
voyages1435703vo_yages
waftages15105393waftages
wantages12109023wantages
wastage11109253wastage_
wattages12106783wattages
wordages1337053wordages

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 Limit1461622206.78321548.3
3Display Results2202200.0932365.6
 (SQL Overall)1786912207.29624491.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.