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

227 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
lineage87898(None) 
linage7713401lin_age
lineages979181lineages
lineate7815151lineate
linkage1295961linkage
alienage945582alienage
blindage1243682blindage
incage93513622_incage
innage73011572_innage
liege65314432li_e_ge
limeade1076122limeade
linages8813172lin_ages
lindane839032lindane
lineable101811082lineable
lineal65616022linea_l
linear65113342linea_r
lineated9711062lineated
linkages1385952linkages
mileage10299312mileage
mintage101110122mintage
pipeage1236202pipeage
sinkage1287262sinkage
vintage11128142vintage
windage1237932windage
acreage1037833acreage
alienages1045973alienages
alienate8311553alienate
anlage72514223_anlage
bandage11311023bandage
binate8419773bin_ate
binge85125513bin__ge
blindages1343663blindages
bondage1138253bondage
cineast9310523cineast
cineaste1045743cineaste
cineole91010003cineole
clientage1242713clientage
coinage10310553coin_age
cuneate9311723cuneate
delineate1047793delineate
dinette8310013dinette
dinge75627303din__ge
disease83213843disease
diverge12347643diverge
dunnage9175213dunnage
encage93713503_encage
engage82812103_engage
enrage72715073_enrage
finagle11238313fin_agle
finale94116763fin_ale
fineable131810333fineable
finesse10187643finesse
hinge95323453hin__ge
ideate7313683_ideate
image81411293_i_mage
inane52820343_in_ane
incaged114010443_incaged
incages103013883_incages
incase83615283_incase
infare9313083_infare
ingate73018243_ingate
inhale9411513_inhale
inlace82513043_inlace
inmate82917363_inmate
innages82911303_innages
innate63917313_innate
insane6314883_insane
intake10510863_intake
interage9314483_interage
invade10157853_invade
inweave1344723_inweave
kinase104210653kin_ase
lanate6421263lan_ate
langrage10106033langrage
language10105003language
lavage1038263l_avage
layerage1244963layerage
leafage1194573leafage
league758743l__eague
leakage1235003leakage
lease55230263l__ease
leave84723723l__eave
ledge76519463l__edge
leverage1285393leverage
liane54720663li__ane
libelee92510983libelee
liberate101113383liberate
librae84310173libra_e
librate93214233librate
licence11119363licence
license9148423license
licente91210893licente
lieges74113443li_e_ges
lienable10188693lienable
lienal63912783liena_l
lierne638023li_erne
lieve86315473li_e_ve
lifecare1364113lifecare
ligase7259913li_gase
ligate72519253li_gate
likeable14166473likeable
limbate1139213limbate
limeades11116643limeades
linable92214343linable
linac7315413lin_a_c
linacs8310813lin_acs
lindanes939173lindanes
line46965573lin___e
lineally1137793lineally
lineament1147843lineament
linearise946433linearise
linearize1845753linearize
linearly1146793linearly
linebred1144963linebred
linecut997983linecut
lined64934643line__d
linelike12159003linelike
lineman939123lineman
linemen938633linemen
linen55728723line__n
linens64818393line_ns
lineny94011443line_ny
lineolate946283lineolate
liner55938923line__r
liners65428853line_rs
lines57054573line__s
linesmen1046563linesmen
lineup835983line_up
lineups934913lineups
liney87029633line__y
ling57447963lin__g_
linga66820823lin__ga
lingam95112353linga_m
lingams104510193lingams
lingas75116573linga_s
linger75226003lin__ger
lingerie959203lingerie
lingo66022113lin__go
lings67135773lin__gs
linguae8398413linguae
lingy96925143lin__gy
lining74526803lining_
linings84313073linings
linkable14187263linkable
linoleate944723linoleate
linsang835863linsang
linsangs944413linsangs
lipase8239103li_pase
liquate1638423liquate
lisente71210703lisente
literate81216893literate
litharge1243823litharge
liveable13177663liveable
lockage1436613lockage
longe66626463lon__ge
lovage1037353l_ovage
lozenge1743243lozenge
luggage1043673luggage
lunate6316043lun_ate
lunette737483lunette
lunge65323803lun__ge
manage93818903man_age
manege94113203mane_ge
menage93216543men_age
milage93414123mi_lage
mileages11249693mileages
millage103112753millage
minae75627723min_a_e
mineable121611053mineable
mintages111110513mintages
mirage92313653mi_rage
misease92713043misease
mispage12310523mispage
montage101211713montage
nonage7313683non_age
nonwage1137163nonwage
peage84723563__peage
pileate93815923pileate
pillage103412603pillage
pineal84817683pinea_l
pineals93212843pineals
pinene82915643pine_ne
pinnace113510313pinnace
pinnae84414643pinna_e
pinnate93613743pinnate
pinwale1257843pinwale
pipage1199143pi_page
pipeages1336423pipeages
renege72713763rene_ge
rivage1038843ri_vage
siege66718443si_e_ge
signage937773signage
silage72715303si_lage
singe65731133sin__ge
sinkages1386853sinkages
sinuate7412163sinuate
slippage13103943slippage
spinage10289653spin_age
tankage12257773tankage
tannage8209583tannage
teenage8108053teenage
tentage81010643tentage
thenage11107843thenage
tillage83111343tillage
tinea54923163tinea__
tineal66216163tinea_l
tineas64616483tinea_s
tinge64626623tin__ge
tinware1038603tinware
tonnage8168053tonnage
tunnage8166373tunnage
uncage93014873_uncage
uneager839753_uneager
unease63816643_unease
unitage838993unitage
vantage11109893vantage
ventage11109623ventage
village113610833village
vineal94814743vinea_l
vinegar1134613vinegar
vintager12104823vintager
vintages12118273vintages
visage1049083vi_sage
wantage11119623wantage
windages1338263windages
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.1401276364.3
2DLD Change Limit1340272276.09321996.9
3Display Results2272270.0762986.8
 (SQL Overall)1786912276.30928323.2
 
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.