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

427 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
levant931449(None) 
leant56737781le_ant
levants1037721levants
avant86224662_avant
bezant17814542bezant
decant93524222decant
deviant11311312deviant
elegant8311502elegant
eluant6315092eluant
event85924442_event
gelant72821672gelant
lean46345242le_an_
leans55536252le_ans
leapt75027472le_apt
learnt64019252learnt
least56134882le_ast
leman75622602leman_
lemans85316392lemans
lent46360532le__nt
leva77020712leva__
levanted1245322levanted
levanter1145302levanter
levin84816412levin_
levins94514652levins
lovat8321042lova_t
meant76537212me_ant
pedant9319492pedant
recant83228682recant
relevant1149242relevant
savant9416042savant
secant84023292secant
sejant133114482sejant
servant10313632servant
tenant6322472tenant
abeyant1248083abeyant
advent102613753advent
alant55742293_alant
alevin92511513alevin_
alevins102110573alevins
alleviant1246143alleviant
alterant8614963alterant
ant37270793___ant
arrant6623253arrant
askant10412713askant
aslant6317753aslant
avast85519363_avast
avaunt959603_avaunt
bean66443863be_an_
beano75421553be_ano
beans75734693be_ans
beast76338643be_ast
beat66168303be_a_t
beaut75135213be_aut
began86319573began_
begat86629723bega_t
bent67759913be__nt
bepaint11312183bepaint
bezants1877343bezants
bezzant1746893bezzant
blatant9310673blatant
bleat75737003ble_a_t
blent76230953ble__nt
brant74742173_brant
byzant2096813byzant
cant66362033__cant
cement103321673cement
cent67451013ce__nt
cetane8315283cetane
chant105932693_chant
clamant11312433clamant
clean75420413cle_an_
cleans85817053cle_ans
cleat76335063cle_a_t
clement11313773clement
dealt65234283de_alt
dean56039483de_an_
deans66131393de_ans
decane93818873decane
decants103514443decants
decent94023703decent
dedans85915073dedans
defang1137753defang
defat95426693defa_t
defiant11311923defiant
demand104314253demand
demast9517063demast
dement93825153dement
dent57158413de__nt
depaint10314593depaint
depart94720563depart
derat65044083dera_t
desalt7518313desalt
desand84812633desand
descant104315593descant
detent73624483detent
deva85720983deva__
devas96218883deva_s
devest104418703devest
deviants1236733deviants
devon95113683devon_
devons104512253devons
devout10712993devout
dewan95718043dewan_
dewans105215143dewans
divan96114843divan_
divans104612393divans
dopant9316133dopant
east46659103_e_ast
eat36989053_e_a_t
elan46734243_elan_
eland65820393_eland
elans55527753_elans
element9317803element
elephant1347563elephant
elevate101110373elevate
eleven988303eleven_
elevens1066803elevens
eleventh1443773eleventh
elevon977953elevon_
elevons1067573elevons
elint55436473_elint
eluants737583eluants
eluent6315483eluent
enact73525363_enact
epact94921533_epact
errant6618733errant
evade938183_evade
even75222273_even_
evens84817103_evens
events94814073_events
evert84929513_evert
evict104417143_evict
exact143516933_exact
exalt123018533_exalt
extant132714753extant
feast85932723fe_ast
feat76458223fe_a_t
feint84732253fe_int
fervent13310063fervent
galavant1246353galavant
galivant1247083galivant
gelants82611443gelants
gellant83214053gellant
gent56954393ge__nt
gerent73223103gerent
giant65430593_giant
glean65818203gle_an_
gleans75014743gle_ans
grant64840023_grant
grievant1244803grievant
hant75461593__hant
heart85440743he_art
heat77061423he_a_t
hent76656383he__nt
hexane16379533hexane
incant82418513incant
infant92315133infant
invent93316363invent
iterant7317783iterant
jean116629283je_an_
jeans126022113je_ans
jessant1438443jessant
jurant134216553jurant
kent86846963ke__nt
lagan66520343lagan_
lagans75717783lagans
lament85024943lament
land56337313l__and
lane45153333l__ane
lang56637383l__ang
lank84734453l__ank
last46260323l__ast
lat37593403l__a_t
latent64124303latent
lauan55216793lauan_
lauans65113533lauans
lava76725423lava__
lavabo1135273lavabo
lavage1038263lavage
lavas85422223lava_s
lavash12597373lavash
laving104623573laving
lea37660183le_a__
leach105422523le_ach
lead56038853le_a_d
leads66028493le_ads
leady95618603le_ady
leaf76441033le_a_f
leafs85721183le_afs
leafy116316213le_afy
leak86233713le_a_k
leaks95923913le_aks
leaky125217723le_aky
leal46043273le_a_l
lealty92910603le_alty
leaned73422543le_aned
leaner64022193le_aner
leanest7415863le_anest
leanly93811503le_anly
leap66032683le_a_p
leaps75522933le_aps
lear47045953le_a_r
learn55322663le_arn
learns65513743learns
lears55938733le_ars
leary85927383le_ary
leas45954183le_a_s
lease55230263le_ase
leash85519213le_ash
leasts64616413le_asts
leave84723723le_ave
leaved105719023leaved
leaven95013073leaven
leavens10409303leavens
leaver94321513leaver
leaves94222383leaves
leaving114216853leaving
leavy115715773le_avy
leben7314853leben_
lebens8310093lebens
leet45957903le__et
left76340483le__ft
legacy1256653legacy
legal65715943lega_l
legals73412733legals
legate72917453legate
legato72810953legato
legend837693legend
legist71315253legist
legit61323503le_git
legman949653legman_
legong836963legong
lekvar1333043lekva_r
lekvars1432693lekvars
lemon75618183lemon_
lemons84415053lemons
lemony11419553lemony
lend56233673le__nd
lenient7313843lenient
leno47331393le__no
lens46146493le__ns
lento57223393le__nto
leone55018823le_one
lept66440883le__pt
lest46956323le__st
let36481473le___t
lev66139423lev___
levanters1254993levanters
levantine1264793levantine
levanting1345523levanting
levator10298963levator
levee84023813lev_ee
leveed104111373leveed
levees93714523levees
level84116553lev_el
levels94113283levels
lever85125163lev_er
leveret103014003leveret
levers94621323levers
levied104111433levied
levier94013873levier
levies93919863levies
levis85818553lev_is
levity1277903levity
levo76820063lev__o
levy106418503lev__y
levying1435873levying
liana53915893l_iana
liane54720663l_iane
liang64914413l_iang
libelant1048563libelant
lievest1048343lievest
ligan67920283ligan_
ligand85011293ligand
ligans76817733ligans
liman75921603liman_
limans84816303limans
lint416266233l__int
litany939053litany
liven85021733liven_
livens94314893livens
livest95315733livest
living104318323living
llano5910603l_lano
loan47436453l_oan_
loans56026463l_oans
logan68123283logan_
logans76319063logans
loment84021473loment
loran55925093loran_
lorans65117603lorans
lovage1037353lovage
lovats939073lovats
loving104416723loving
lucent8313823lucent
lunt46148843l__unt
lyart85121883l_yart
mean65538093me_an_
means75831233me_ans
meany104620483me_any
meat66359603me_a_t
mediant103516703mediant
mutant8317693mutant
natant6318733natant
neat46356783ne_a_t
nutant6316383nutant
octant81216553octant
operant9317223operant
pant66061263__pant
pavan106518473pavan_
pavane114113443pavane
pavans115715593pavans
pean66147173pe_an_
peans75437643pe_ans
peanut8318183pe_anut
peart76440753pe_art
peasant9314923peasant
peat65967933pe_a_t
pecan91919033pecan_
pecans101515833pecans
peccant13311733peccant
pedants10310113pedants
pekan111613973pekan_
pekans121710553pekans
penang92511113penang
pendant10314853pendant
pennant9312493pennant
pent66559073pe__nt
plant75437113_plant
pleasant1048323pleasant
pleat74734473ple_a_t
pliant83918823pliant
prevent124016553prevent
quant143624813_quant
rant45864683__rant
react74634333re_act
rebait8320403rebait
reboant9315093reboant
recane83022873recane
recants93217093recants
recast83422773recast
recent83630853recent
redact9419043redact
redan66125013redan_
redans75421023redans
regent74127673regent
regnant8312843regnant
regrant8317323regrant
rehang1039823rehang
reland75920433reland
relent64431853relent
reliant7319243reliant
reman75730153reman_
remand95618963remand
remans84823003remans
remint85329983remint
remnant9312643remnant
rent46661243re__nt
repaint9318363repaint
repand95316063repand
repast83520633repast
repent84728873repent
replant93318533replant
reptant92817073reptant
reran57329103reran_
rerent63832453rerent
resat55139683resa_t
resent63833623resent
retint65633443retint
revamp1336013revamp
revenant11410283revenant
revert93529113revert
revest94623603revest
revet84938843rev_et
revolt9316223revolt
rewan85623663rewan_
riant55833153_riant
savants1038653savants
scant79735073_scant
sealant73118303sealant
seat47575563se_a_t
seawant103613413seawant
secants93413893secants
sedan65620423sedan_
sedans74816093sedans
sejeant1489723sejeant
sent46963013se__nt
servants1138003servants
seven84118313seven_
sevens93813663sevens
seventh1336773seventh
seventy1338033seventy
sewan85921293sewan_
sewans95215903sewans
sextant142911963sextant
slant55238703_slant
sonant6621953sonant
teat45963633te_a_t
tenants7311013tenants
tent46159863te__nt
tetany959843tetany
tolerant8411463tolerant
truant6315783truant
tyrant9315333tyrant
ululant747693ululant
vacant11415133vacant
van66246333__van_
vane75534693__vane
vang84926043__vang
vans76236733__vans
vast75045123__vast
vat67863453__va_t
vaunt85925313__vaunt
vegan95114153vegan_
vegans103910853vegans
vent76049053__vent
verdant11313293verdant
versant10313833versant
volant9316323volant
want76156173__want
wean75734353we_an_
weans85326743we_ans
went76051873we__nt
yean75834583ye_an_
yeans86624883ye_ans
yeast85327943ye_ast
zenana15297983zenana

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.470380193.6
2DLD Change Limit1127164275.28021347.7
3Display Results4274270.1403050.0
 (SQL Overall)1786914275.89030338.0
 
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.