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

233 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
length104610(None) 
lengths1144081lengths
lengthy1452731lengthy
lengthen1243532lengthen
lenite6719982lenite
lenity9612712lenity
lent46360532len_t_
lento57223392len_to
tenth85421832ten_th
zenith1839072zenith
bench125619503ben_ch
beneath1236973beneath
bent67759913ben_t_
bento75922953ben_to
bents76033693ben_ts
berth104917883be_rth
beth96629233be__th
blench133710453blen_ch
blent76230953blen_t_
cenote83715843cenote
cent67451013cen_t_
cento76625173cen_to
cents74730333cen_ts
centu76119413cen_tu
clench133910053clen_ch
dearth104212513dearth
death94822523de_ath
dengue838253dengue
denote74118043denote
dent57158413den_t_
dents65031803den_ts
depth114311853de_pth
earth85023053_earth
eath75735663_e_ath
eight94928053_eight
eighth133310603_eighth
enate54428143_enate
eng46726783_eng__
engs56121393_eng_s
eth66630983_e__th
flench144010813flen_ch
genet66038683genet_
genets75716663genets
gent56954393gen_t_
gents65729613gen_ts
health124712143health
hearth125315213hearth
heath115724283he_ath
heigh124812543heig_h
height134713433height
heighth13366343heighth
henge94819823heng_e
henges104516453henges
hent76656383hen_t_
hents87330743hen_ts
heth107028023he__th
heugh125410923heug_h
kench145513923ken_ch
kent86846963ken_t_
kente95821063ken_te
laigh95515923laig_h
laith85722103l_aith
lanate6421263lanate
lang56637383lang__
langue71012173langue
langur7109303langur
lath76640383l__ath
laugh94414373laug_h
leach105422523le_ach
league758743league
lealty92910603lealty
leant56737783leant_
leapt75027473leapt_
leash85519213le_ash
least56134883least_
leasts64616413leasts
lech96825443le__ch
lecythi1542433lecythi
ledge76519463ledg_e
ledger85914363ledger
ledges84917983ledges
ledgy105712013ledg_y
leech104913213le_ech
leet45957903le_et_
leets54927123le_ets
left76340483le_ft_
lefts86517813le_fts
lefty115613563le_fty
leg46446113le_g__
legal65715943le_gal
legate72917453legate
legato72810953legato
leger65721503le_ger
leges64427283le_ges
legged95713083legged
leggin8268593leggin
leggy105210243le_ggy
legit61323503le_git
legits71313003legits
legs56133693le_g_s
lekythi1741623lekythi
lend56233673len__d
lender73921273lender
lends65326253len_ds
lenes54738523len_es
lengthens1343353lengthens
lengthier1342413lengthier
lengthily1642043lengthily
lenis56326863len_is
lenited8812433lenited
lenites7818443lenites
leno47331393len__o
lenos56024863len_os
lens46146493len__s
lense54523433len_se
lensed74015473lensed
lenses64620893lenses
lenten6312883lenten
lentic83515743lentic
lentil64315393lentil
lentos65317403lentos
lept66440883le_pt_
lepta75714393le_pta
lest46956323le_st_
let36481473le__t_
letch105215803le_tch
lethe85717303le__the
lets47147943le__ts
levity1277903levity
light94429603l_ight
ling57447963ling__
linga66820823ling_a
lingam95112353lingam
lingas75116573lingas
linger75226003linger
lingo66022113ling_o
lings67135773ling_s
lingua7509913lingua
lingy96925143ling_y
lint416266233lin_t_
lints57137193lin_ts
linty87126563lin_ty
liroth938383liroth
loath84918603l_oath
long56933343long__
longan75612363longan
longe66626463long_e
longed87121373longed
longer75823203longer
longes75925573longes
longish11229093longish
longly10279603longly
longs65527063long_s
loth76132133l__oth
lough95118483loug_h
lunate6316043lunate
lunch104917243lun_ch
lunet56835423lunet_
lunets66914763lunets
lung55732493lung__
lungan74710213lungan
lunge65323803lung_e
lunged85418273lunged
lungee75119813lungee
lunger75720423lunger
lunges76123423lunges
lungi65516053lung_i
lungis77113023lungis
lungs65223883lung_s
lungyi10525093lungyi
lunt46148843lun_t_
lunts55826903lun_ts
lynch13468983lyn_ch
mensch13387093mensch
mensh105413553men_sh
menta74424423men_ta
meth95827843me__th
month104818423mon_th
neath86020283ne_ath
neigh94912383neig_h
ninth8314583nin_th
nth66320593__n_th
pengo84317593peng_o
pengos94612413pengos
pent66559073pen_t_
plench134010813plen_ch
plenish1239943plenish
plenty11311413plen_ty
plinth11310453plin_th
rent46661243ren_t_
rente54733783ren_te
rents55935183ren_ts
sangh95517453sang_h
senate63725143senate
sengi64016513seng_i
seniti64317223seniti
sent46963013sen_t_
sente56432873sen_te
senti56226703sen_ti
sleigh10258203sleig_h
sleight11279023sleight
sleuth937233sle_uth
snath86419803_snath
stengah1144563stengah
strength1244433strength
synth113711823syn_th
teeth87315853te_eth
tench105620003ten_ch
tenet55542213tenet_
tenets65518953tenets
tenge65720433teng_e
tent46159863ten_t_
tenths94412663ten_ths
tents56434213ten_ts
tenty86121603ten_ty
tenuti638973tenuti
tenuto648743tenuto
teth76327893te__th
teugh95511613teug_h
venge95117983veng_e
venged114011983venged
venges104015143venges
vent76049053ven_t_
vents86125933ven_ts
wealth12379223wealth
weigh125412513weig_h
weight133914183weight
wench136214783wen_ch
went76051873wen_t_
yenta83917043yen_ta
yente86220043yen_te
zeniths1935153zeniths
zeroth1837963zeroth

Search took 6 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162335.07622205.7
3Display Results2332330.0633698.4
 (SQL Overall)1786912335.27933849.4
 
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.