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

182 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
linkage129596(None) 
linage7713401lin_age
lineage878981lineage
linkages1385951linkages
sinkage1287261sinkage
blindage1243682blindage
incage93513622_incage
innage73011572_innage
leakage1235002leakage
linages8813172lin_ages
lindane839032lindane
lineages979182lineages
lineate7815152lineate
linkable14187262linkable
lockage1436612lockage
mintage101110122mintage
sinkages1386852sinkages
tankage12257772tankage
vintage11128142vintage
windage1237932windage
alienage945583alienage
anlage72514233_anlage
bandage11311023bandage
binate8419773bin_ate
binge85125513bin__ge
blindages1343663blindages
blinkard1543043blinkard
blockage1744103blockage
bondage1138253bondage
boskage1465413boskage
brokage1436673brokage
bulkage1435703bulkage
clientage1242713clientage
coinage10310553coin_age
corkage1438373corkage
dinge75627303din__ge
dockage1535723dockage
dunnage9175213dunnage
encage93713503_encage
engage82812103_engage
enrage72715073_enrage
finagle11238313fin_agle
finale94116763fin_ale
flinkite1543623flinkite
ginkgo12334943gink_go
hinge95323453hin__ge
image81411293_i_mage
inane52820343_in_ane
incaged114010443_incaged
incages103013883_incages
incase83615283_incase
infare9313083_infare
ingate73018243_ingate
inhale9411513_inhale
inkle94515833_ink_le
inlace82513043_inlace
inmate82917363_inmate
innages82911303_innages
innate63917313_innate
insane6314893_insane
intake10510863_intake
invade10157853_invade
kinase104210653kin_ase
lanate6421263lan_ate
langrage10106033langrage
language10105003language
lavage1038263l_avage
leafage1194573leafage
leakages1334933leakages
liane54720663li__ane
librae84310173libra_e
librate93214233librate
liege65314433li__ege
ligase7259913li_gase
ligate72519253li_gate
likable13219413li_kable
like86040843li_k__e
limbate1139213limbate
limeade1076123limeade
linable92214343linable
linac7315413lin_a_c
linacs8310813lin_acs
lindanes939173lindanes
line46965573lin___e
lineable101811083lineable
lineal65616023linea_l
linear65113343linea_r
lineated9711063lineated
ling57447963lin__g_
linga66820823lin__ga
lingam95112353linga_m
lingams104510193lingams
lingas75116573linga_s
linger75226003lin__ger
lingo66022113lin__go
lings67135773lin__gs
linguae8398413linguae
lingy96925143lin__gy
lining74526803lining_
linings84313073linings
link86943443link___
linkboy1643173linkboy
linked114518213link_ed
linker104321473link_er
linkers114317713linkers
linking123818253linking
linkman1335393linkman
linkmen1335363linkmen
links96430193link__s
linksmen1443523linksmen
linkup1245123link_up
linkups1333633linkups
linky127622383link__y
linsang835863linsang
linsangs944413linsangs
lipase8239103li_pase
liquate1638423liquate
litharge1243823litharge
lockages1536723lockages
longe66626463lon__ge
lovage1037353l_ovage
luggage1043673luggage
lunate6316043lun_ate
lunge65323803lun__ge
manage93818903man_age
menage93216543men_age
milage93414123mi_lage
mileage10299313mileage
millage103112753millage
minae75627723min_a_e
minke115421763mink__e
mintages111110513mintages
mirage92313653mi_rage
mispage12310523mispage
montage101211713montage
nonage7313683non_age
nonwage1137163nonwage
package16128013package
pickaxe2244623pickaxe
pikake11115803pi_kake
pillage103412603pillage
pinkeye16326493pinkeye
pinkie124414273pink_ie
pinnace113510313pinnace
pinnae84414643pinna_e
pinnate93613743pinnate
pinwale1257843pinwale
pipage1199143pi_page
pipeage1236203pipeage
rivage1038843ri_vage
shrinkage1741903shrinkage
signage937773signage
silage72715303si_lage
singe65731133sin__ge
sinkable14178413sinkable
sinuate7412163sinuate
slippage13103943slippage
soakage1236103soakage
spinage10289653spin_age
tankages13217113tankages
tannage8209583tannage
tentage81010643tentage
tillage83111343tillage
tinge64626623tin__ge
tinkle103714453tink_le
tinware1038603tinware
tonnage8168053tonnage
tunnage8166373tunnage
uncage93014873_uncage
unitage838993unitage
vantage11109893vantage
ventage11109623ventage
village113610833village
vintager12104823vintager
vintages12118273vintages
visage1049083vi_sage
wantage11119623wantage
wickape1843723wickape
windages1338263windages
winkle133812833wink_le
zincate1838533zincate
zingare1737143zingare

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.390458182.1
2DLD Change Limit1340271826.06322105.7
3Display Results1821820.0762394.7
 (SQL Overall)1786911826.52927368.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.