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

520 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
tenant632247(None) 
tenants7311011tenants
bezant17814542bezant
cotenant10511792cotenant
decant93524222decant
enact73525362_enact
gelant72821672gelant
iterant7317782iterant
leant56737782le_ant
levant9314492levant
meant76537202me_ant
pedant9319492pedant
penang92511112penang
pendant10314852pendant
pennant9312492pennant
recant83228682recant
regnant8312842regnant
remnant9312632remnant
secant84023292secant
sejant133114482sejant
setenant849922setenant
sonant6621952sonant
teat45963632te_a_t
tenace82715692tenace
tenail64516102tenail
tenancy1237502tenancy
tenanted937042tenanted
tenantry1144262tenantry
tenet55542212ten_et
tenon53320512tenon_
tenons62916602tenons
tent46159862te__nt
tetany959842tetany
truant6315782truant
tyrant9315332tyrant
zenana15297982zenana
abeyant1248083abeyant
alant55742293_alant
alterant8614963alterant
alternant977133alternant
anent54931843_anent
ant37270783___ant
arrant6623253arrant
askant10412713askant
aslant6317753aslant
attendant1045473attendant
avant86224663_avant
banana83213413banana
bean66443863be_an_
beano75421553be_ano
beans75734693be_ans
beast76338643be_ast
beat66168303be_a_t
beaut75135213be_aut
began86319573began_
begat86629723bega_t
bename103316073bename
benne76521123ben_ne
bennet84823363bennet
benni74715363ben_ni
benny105217363ben_ny
bent67759913be__nt
bepaint11312183bepaint
bezants1877343bezants
bezzant1746893bezzant
brant74742173_brant
byzant2096813byzant
cant66362023__cant
cement103321663cement
cent67451013ce__nt
cetane8315283cetane
chant105932693_chant
coenact11311803coenact
cotenants1147283cotenants
covenant1349693covenant
dealt65234283de_alt
dean56039483de_an_
deans66131393de_ans
decane93818873decane
decants103514443decants
decent94023703decent
dedans85915073dedans
defang1137753defang
defat95426693defa_t
defiant11311923defiant
demand104314253demand
demast9517063demast
dement93825143dement
denar65223293dena_r
denari710917353denari
denars74621433denars
denary105316863denary
dent57158413de__nt
depaint10314593depaint
depart94720563depart
derat65044083dera_t
desalt7518313desalt
desand84812633desand
descant104315583descant
detent73624483detent
deviant11311313deviant
dewan95718043dewan_
dewans105215143dewans
dopant9316133dopant
dynast1088223dynast
east46659103_e_ast
eat36989053_e_a_t
elan46734243_elan_
eland65820393_eland
elans55527753_elans
elegant8311503elegant
elint55436473_elint
eluant6315093eluant
emanant9411083emanant
enacts84012973_enacts
enate54428143_enate
enchant12313103_enchant
enrapt8313013_enrapt
entrant7318873_entrant
epact94921533_epact
errant6618733errant
etchant1249813etchant
ethane94613243ethane
etna46415263etna__
etnas54713933etna_s
event85924443_event
exact143516933_exact
exalt123018533_exalt
extant132714753extant
feast85932723fe_ast
feat76458223fe_a_t
feint84732253fe_int
fenland1135693fenland
fenny115115133fen_ny
fondant11311143fondant
gelants82611443gelants
gellant83214053gellant
genet66038683gen_et
gent56954393ge__nt
gerent73223093gerent
giant65430593_giant
gnat56034433_gna_t
grant64840023_grant
hant75461583__hant
heart85440743he_art
heat77061423he_a_t
henbane1237353henbane
henbit111412003henbit
henna84414043hen_na
hennas94211803hennas
hent76656383he__nt
hexane16379533hexane
honan85319773honan_
honans94814503honans
inane52820343_inane
inapt73522693_inapt
incant82418503incant
infant92315133infant
intendant1047713intendant
jean116629283je_an_
jeans126022113je_ans
jennet134714953jennet
jenny153811623jen_ny
jessant1438443jessant
jnana12159043_jnana
jurant134216553jurant
kenaf12316033kena_f
kenafs1337113kenafs
kent86846963ke__nt
lean46345243le_an_
leans55536253le_ans
leapt75027473le_apt
learnt64019253learnt
least56134883le_ast
leman75622603leman_
lemans85316393lemans
lenient7313843lenient
lent46360533le__nt
levants1037723levants
manana84816073manana
manat76039983mana_t
mean65538083me_an_
means75831223me_ans
meany104620473me_any
meat66359603me_a_t
mediant103516703mediant
menace103216943menace
menad85918983mena_d
menads95514383menads
menage93216543menage
meninx1538703meninx
mutant8317693mutant
nan37854873__nan_
nana46632893__nana
nans46139393__nans
natant6318733natant
neat46356783ne_a_t
nonart6319193nonart
nutant6316383nutant
octant81216553octant
operant9317223operant
pant66061253__pant
pean66147173pe_an_
peans75437643pe_ans
peanut8318183peanut
peart76440753pe_art
peasant9314923peasant
peat65967933pe_a_t
pecan91919033pecan_
pecans101515833pecans
peccant13311733peccant
pedants10310113pedants
pekan111613973pekan_
pekans121710553pekans
penal75228373pena_l
penalty1267743penalty
penance11313443penance
penangs10268373penangs
penchant1549563penchant
pendants1139093pendants
pendent10314723pendent
penman10312323penman_
penna74520203pen_na
pennae84314033pennae
pennants1037063pennants
pennate93314033pennate
penne75423853pen_ne
penni74617903pen_ni
penny105119453pen_ny
pent66559073pe__nt
pentane9415743pentane
penult8314653penult
pinang92611593pinang
plant75437113_plant
pliant83918823pliant
ponent82821593ponent
pregnant1149883pregnant
qanat144426843qana_t
quant143624813_quant
rant45864673__rant
react74634333re_act
rebait8320403rebait
reboant9315093reboant
recane83022873recane
recants93217093recants
recast83422773recast
recent83630853recent
redact9419043redact
redan66125013redan_
redans75421023redans
reenact9413003reenact
regent74127673regent
regrant8317323regrant
rehang1039823rehang
reland75920433reland
relent64431853relent
reliant7319243reliant
reman75730153reman_
remand95618963remand
remans84823003remans
remint85329973remint
remnants1036843remnants
renail65020763renail
renal55929503rena_l
rename82718813rename
renest64529713renest
renin54830033renin_
renins64526453renins
rennet64624853rennet
rent46661243re__nt
repaint9318363repaint
repand95316063repand
repast83520633repast
repent84728873repent
replant93318533replant
reptant92817073reptant
reran57329103reran_
rerent63832453rerent
resat55139683resa_t
resent63833623resent
resonant8410813resonant
retint65633443retint
revenant11410273revenant
rewan85623663rewan_
riant55833153_riant
savant9416043savant
scant79735073_scant
sealant73118303sealant
seat47575563se_a_t
seawant103613413seawant
secants93413893secants
sedan65620423sedan_
sedans74816093sedans
sejeant1489723sejeant
senary93716073senary
senate63725143senate
senna54617983sen_na
sennas64214233sennas
sennet64224143sennet
sennit63117923sennit
sent46963013se__nt
servant10313623servant
setenants945973setenants
sewan85921293sewan_
sewans95215903sewans
sextant142911963sextant
slant55238703_slant
sonants7511233sonants
stagnant946893stagnant
statant7313123statant
stent55634513ste__nt
subtenant1146503subtenant
tact67349033t__act
taggant9310213taggant
taint55542283t_aint
talent6323323talent
tan37167563t__an_
tang56138663t__ang
tangent8314993tangent
tanist6324593tanist
tank85134013t__ank
tannate71813523tannate
tans46154813t__ans
tanto55724943t__anto
tart47566183t__art
tat37690293t__a_t
taunt55532283t_aunt
taut47048963t__aut
tea37353323te_a__
teacart91113193teacart
teach105221123te_ach
teak85930843te_a_k
teaks94222903te_aks
teal45546503te_a_l
teals56234133te_als
team66238653te_a_m
teams75726513te_ams
teapot8416763teapot
tear45242883te_a_r
tears55436463te_ars
teary85124053te_ary
teas45851493te_a_s
tease55428713te_ase
teats55636813te_ats
techno1135953techno
teeing73916973teeing
teen45938203te_en_
teenage8108053teenage
teens56227483te_ens
teeny85417883te_eny
teind6213613te_ind
tela45532973tela__
telae54323293tela_e
telnet6518833telnet
tempt95124843te_mpt
ten35856113te__n_
tenable93214493tenable
tenably122210453tenably
tenaces92814513tenaces
tenacity1347113tenacity
tenails73713923tenails
tenanting1036213tenanting
tench105620003ten_ch
tend56433773te__nd
tendance1147523tendance
tended83819483tended
tender74121843tender
tending94419163tending
tendon7312033tendon
tendons8311473tendons
tends65425583ten_ds
tendu67216003ten_du
tendus75111183tendus
tenement10412593tenement
tenets65518953tenets
tenge65720433ten_ge
tenia55324483ten_ia
teniae64517353teniae
tenias64720073tenias
tenner64117103tenner
tennis64015303tennis
tennist72813113tennist
tenoned839363tenoned
tenoner739673tenoner
tenor53620253ten_or
tenors63217753tenors
tenour62610733tenour
tenpin8310583tenpin
tenpins9410073tenpins
tenrec837513tenrec
tens45647413te__ns
tense55225843ten_se
tensed74817833tensed
tenser64919433tenser
tenses64722553tenses
tensest72713313tensest
tensing84616653tensing
tensity1039103tensity
tensor63812673tensor
tentage81010643tentage
tented74221003tented
tenter64623933tenter
tenth85421833ten_th
tenths94412663tenths
tentie62521183tentie
tenting84621153tenting
tents56434213ten_ts
tenty86121603ten_ty
tenues63816443tenues
tenuis64213083tenuis
tenuity1037453tenuity
tenure6311613tenure
tenuti638973tenuti
tenuto648743tenuto
teopan839353teopan_
teopans939203teopans
tepa66021683tepa__
tepal76319583tepa_l
tepals85415043tepals
tepas76521683tepa_s
terai53525483tera_i
terais64023503terais
teraph11319093teraph
tercet83624913tercet
tern46134803te_rn_
ternary1038343ternary
ternate7415483ternate
terne56426153te_rne
terns55226873te_rns
terrane72814223terrane
terret63425623terret
territ63421373territ
test48651623te__st
tet39274983te___t
tetanal738023tetanal
tetanic9810133tetanic
tetanus737933tetanus
tewing103914823tewing
texas126514933texa_s
text116033933te__xt
than76128773t_han_
thane86122533t_hane
thank125817803t_hank
that75639323t_ha_t
thenage11107833thenage
thenal92712413thena_l
thenar9269993thena_r
thenars10248503thenars
thwart12311683thwart
tinct76126233tin_ct
tining74927543tining
tinman82411123tinman_
tinny85317653tin_ny
tinpot8312513tinpot
tint46758863t__int
tisane6311573tisane
titan53318173titan_
titans63414913titans
titrant7315193titrant
toast55831013t_oast
toenail738773toenail
tolan55124013tolan_
tolane64316583tolane
tolans64319273tolans
tolerant8411463tolerant
toman75724053toman_
tomans85419133tomans
tonal53724303tona_l
toning74025793toning
tonlet62924703tonlet
tonne54921433ton_ne
tract75635713t_ract
trait56940843t_rait
trank96222423t_rank
tranny94210863tranny
tranq145416893t_ranq
trans54933043t_rans
trapt76433393t_rapt
treat56240353trea_t
trenail7410803trenail
trenchant1446323trenchant
trepan82511673trepan_
trepang10257293trepang
trepans92311593trepans
truants738153truants
tuna45127843tuna__
tunas54224123tuna_s
tuning74016843tuning
tunny86515033tun_ny
twang94511853t_wang
twat75831513t_wa_t
tyning105510413tyning
tyrants1037453tyrants
unapt710421593_unapt
vacant11415133vacant
vegan95114153vegan_
vegans103910853vegans
vena76126293vena__
venae85920983vena_e
venal85523213vena_l
venene92912523venene
venin85118663venin_
venine93718433venine
venins93816703venins
vent76049053ve__nt
verdant11313293verdant
versant10313833versant
volant9316323volant
want76156163__want
wean75734353we_an_
weans85326743we_ans
wenny114412463wen_ny
went76051873we__nt
xenon122612453xenon_
xenons132710483xenons
yean75834583ye_an_
yeans86624883ye_ans
yeast85327943ye_ast
zanana153810363zanana
zenanas16286233zenanas

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127165206.14018357.7
3Display Results5205200.2502080.0
 (SQL Overall)1786915206.53027364.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.