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

228 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
hostage11311123(None) 
hostages122311691hostages
postage103214851postage
boscage1276532boscage
boskage1465412boskage
costae85319682costa_e
costate94019272costate
cottage104210572cottage
dosage82810002dos_age
dotage82711612do_tage
footage1148842footage
hastate10313912hastate
homage121210602ho_mage
hosta85917832hosta__
hostas94515822hosta_s
hostile10312552hostile
montage101211712montage
onstage838362onstage
outage72017532_outage
portage103013642portage
postages112815322postages
potage92715902po_tage
pottage103310602pottage
restage83316192restage
rootage839052rootage
shortage1236312shortage
stage65330192__stage
upstage10167442upstage
voltage1136862voltage
wastage11109252wastage
aortae65115473aorta_e
apostate1049853apostate
assuage835683assuage
asswage1144673asswage
bistate9313823bistate
bondage1138253bondage
borage93917013bo_rage
boscages1366643boscages
boskages1565423boskages
cartage10312593cartage
chantage1446633chantage
coinage10310553coinage
collage102813753collage
cordage11310063cordage
corkage1438373corkage
corsage1039803corsage
cortege1098943cortege
costa75523733costa__
costal85419513costa_l
costar85518613costa_r
costard104113353costard
costars94218013costars
costive12312843costive
costume1157853costume
cottae84615703cotta_e
cottager11306813cottager
cottages113310493cottages
cottagey14305233cottagey
courage10310993courage
cowage12310663co_wage
cowhage1636293cowhage
cuttage10318343cuttage
dockage1535723dockage
dosages92310803dos_ages
dotages92311793do_tages
downstage1443373downstage
ecotage1036883ecotage
estate64719763_estate
floatage1244403floatage
flotage1136683flotage
foggage1334113foggage
foliage1147533foliage
footages1239053footages
forage104617003fo_rage
forestage1346973forestage
fossae95510373fossa_e
fossate10388603fossate
fosterage1344663fosterage
frontage1296243frontage
frottage1245083frottage
gestate83614073gestate
haste85927863hast__e
haulage1136913haulage
haylage1436443haylage
hectare1238463hectare
hektare1435503hektare
helotage1245713helotage
heptane1238363heptane
herbage1337003herbage
heritage1246533heritage
hesitate1169973hesitate
histogen1245563histogen
histone10312843histone
hoagie102310013ho__agie
hoagy124710473ho__agy
hoecake1645203hoecake
hogmane1336343hogmane
hogtie102711773hogt_ie
homaged1497413ho_maged
homager13107853ho_mager
homages131011583ho_mages
homepage1644933homepage
horste94817413horst__e
hose76547243hos___e
hosing103421103hosing_
hospice14117063hospice
host77852833host___
hosted105020343host_ed
hostel93914153host_el
hosteled1237283hosteled
hosteler1137273hosteler
hostels103712313hostels
hostess103210243hostess
hostiles11312213hostiles
hosting114318383hosting
hostler103411023hostler
hostly124210863host_ly
hosts85526703host__s
hotcake1644543hotcake
hottie92514383ho_ttie
hustle93113993hust_le
instate71616483instate
jostle13319863jost_le
lockage1436613lockage
lovage1037353lo_vage
massage1039893massage
meltage1037953meltage
message1037833message
metage93114453_metage
mintage101110123mintage
mispage12310523mispage
mistake131312623mistake
montaged12107763montaged
montages111412183montages
montane91313623montane
moorage1038743moorage
mortgage1244213mortgage
moste75925083most__e
moulage1037903moulage
nonage7313683no_nage
nonwage1137163nonwage
notate63217863no_tate
octane81411633_octane
octave11157343_octave
offstage1541903offstage
ohmage1295063_ohmage
outages82317323_outages
outate62923403_outate
outrage82616893_outrage
passage1039803passage
plottage1144433plottage
portaged12228463portaged
portages112613223portages
postal84317533posta_l
postals93716373postals
postbag1245223postbag_
postbags1345293postbags
postbase1246443postbase
postdate1139653postdate
postface1566123postface
postgame1345523postgame
postie84123963post_ie
postrace12310533postrace
posture9313253posture
potages102416423po_tages
pottages112910453pottages
prostate10314533prostate
restaged103011863restaged
restages92815773restages
restate73824883restate
rootages939103rootages
roseate7613453roseate
rostrate8313843rostrate
rotate63320343ro_tate
sage55044593__s_age
scutage1036333scutage
septage1078403septage
shortages1336513shortages
soakage1236103soakage
socage91012123so_cage
soccage1236283soccage
soilage8169353soilage
soutane7312063soutane
stade64825303__stade
stag57332003__stag_
staged84521563__staged
stager74821343__stager
stages75629493__stages
stagey105915583__stagey
stags66226743__stags
stagy96618893__stagy
stake95927533__stake
stale55637103__stale
stane55933003__stane
stare54440263__stare
state56237333__state
stave85324993__stave
substage11117183substage
swage94919563__swage
tentage81010643tentage
testae64216253testa_e
testate73916233testate
tollage82610163tollage
tonnage8168053tonnage
tostada894953tostada
tostado895953tostado
towage1039833to_wage
unitage838993unitage
unstate71916213unstate
upstaged12135243upstaged
upstager11164633upstager
upstages11147373upstages
upstare9158683upstare
upstate91610493upstate
usage6410213_us_age
vantage11109893vantage
ventage11109623ventage
vestige1137433vestige
vintage11128143vintage
visage1049083vis_age
voltages1237253voltages
vorlage1136403vorlage
voyage1335473vo_yage
waftage14115323waftage
wantage11119623wantage
wastages12109753wastages
wattage1186983wattage
wordage1236503wordage

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 Filter1786911340270.1401276364.3
2DLD Change Limit1340272286.28021341.9
3Display Results2282280.0802850.0
 (SQL Overall)1786912286.50027490.9
 
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.