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

194 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
lineages97918(None) 
linages8813171lin_ages
lineage878981lineage_
linkages1385951linkages
alienages1045972alienages
blindages1343662blindages
incages103013882_incages
innages82911302_innages
lieges74113442li_e_ges
limeades11116642limeades
linage7713402lin_age_
lindanes939172lindanes
lineate7815152lineate_
lineated9711062lineated
linkage1295962linkage_
mileages11249692mileages
mintages111110512mintages
pipeages1336422pipeages
sinkages1386852sinkages
vintages12118272vintages
windages1338262windages
acreages1138363acreages
alienage945583alienage_
alienates9310683alienates
anlages82414103_anlages
bandages12310633bandages
binges93923123bin__ges
blindage1243683blindage_
bondages1237893bondages
cineastes1165563cineastes
cineasts1045543cineasts
cineoles10109403cineoles
clientages1342793clientages
coinages11310803coin_ages
delineates1147123delineates
dinettes9310193dinettes
dinges83825423din__ges
diseases92415813diseases
diverges13258313diverges
dunnages10154933dunnages
encages103313783_encages
engages92912493_engages
enrages83114853_enrages
finagles12237553fin_agles
finales104016013fin_ales
fineries112416743fineries
finesses111912343finesses
hinges105121033hin__ges
ideates8313733_ideates
images91411463_i_mages
inanes62519803_in_anes
incage93513623_incage_
incaged114010443_incaged
incases93615973_incases
infares10313023_infares
ingates82716913_ingates
inhales10511863_inhales
inlaces92512903_inlaces
inmates92715783_inmates
innage73011573_innage_
intakes11310943_intakes
invades11118293_invades
inweaves1445043_inweaves
kinases113511123kin_ases
kineses113111253kine_ses
langrages11105903langrages
languages11115053languages
lavages1138603l_avages
layerages1345303layerages
leafages1244623leafages
leagues837943l__eagues
leakages1334933leakages
leases65428113l__eases
leaves94222383l__eaves
ledges84917983l__edges
leges64427283l__e_ges
leverages1365663leverages
lianes63819323li__anes
libelees10227213libelees
liberates111012943liberates
librates103412953librates
licences12129323licences
licenses10118923licenses
liege65314433li_e_ge_
liernes739623li_ernes
lifecares1463813lifecares
ligases82310713li_gases
ligates82318383li_gates
limeade1076123limeade_
linacs8310813lin_a_cs
lindane839033lindane_
lindies8416583lin_dies
lineable101811083lineable
lineal65616023linea__l
lineally1137793lineally
lineament1147843lineament
lineaments1245503lineaments
linear65113343linea__r
linearise946433linearise
linearises1046343linearises
linearizes1945723linearizes
linearly1146793linearly
linebred1144963linebred
linecuts1094553linecuts
lineless82711943lineless
linemen938633line_men
linens64818393line__ns
linerless936333linerless
liners65428853line__rs
lines57054573lin___es
linesmen1046563linesmen
lineups934913line_ups
lingams104510193linga_ms
lingas75116573lin__gas
linger75226003lin__ger
lingeries10511813lingeries
lingers84223303lin__gers
lingoes84014693lin_goes
lings67135773lin__g_s
linings84313073lining_s
linoleates1044953linoleates
linsangs944413linsangs
lionesses939433lionesses
lipases9209483li_pases
liquates1737453liquates
literates91415653literates
litharges1344143litharges
liveries11314373liveries
lockages1536723lockages
longes75925573lon__ges
lovages1138033l_ovages
lozenges1843053lozenges
luggages1143633luggages
lunettes836753lunettes
lunges76123423lun__ges
manages103418963man_ages
maneges103612143mane_ges
menages103615393men_ages
milages103114403mi_lages
mileage10299313mileage_
millages113212903millages
mintage101110123mintage_
mirages102213533mi_rages
miseases102614343miseases
mispages13311183mispages
montages111412183montages
nineties8312913nineties
nonages8313843non_ages
peages94321843__peages
pillages113012613pillages
pineals93212843pinea_ls
pinenes93416673pine_nes
pineries102419083pineries
pinnaces12268863pinnaces
pinwales1367963pinwales
pipages1289423pi_pages
pipeage1236203pipeage_
reneges82513593rene_ges
rivages1138873ri_vages
sieges73816833si_e_ges
signages1037483signages
silages82514443si_lages
singes74326853sin__ges
sinkage1287263sinkage_
sinuates8310963sinuates
slippages1483983slippages
spinages11289293spin_ages
tankages13217113tankages
tannages9228963tannages
tentages91011043tentages
thenages12107483thenages
tillages93011263tillages
tineas64616483tinea__s
tinges74722333tin__ges
tinwares1137913tinwares
tonnages9187873tonnages
tunnages9195903tunnages
uncages103213773_uncages
uneager839753_uneager
uneases73316263_uneases
unitages938273unitages
vantages12119023vantages
ventages12119773ventages
villages123010603villages
vinegars1245063vinegars
vineries112716043vineries
vintage11128143vintage_
vintager12104823vintager
vintagers13123903vintagers
visages1138693vi_sages
wantages12109023wantages
windage1237933windage_
wineries112316533wineries
zincates1937743zincates

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 Filter1786911461620.1531167915.0
2DLD Change Limit1461621946.40622816.4
3Display Results1941940.0802425.0
 (SQL Overall)1786911946.63926915.3
 
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.