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

295 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
bezants187734(None) 
bezant17814541bezant_
bezzants1843641bezzants
byzants2153221byzants
beanos85516512be_anos
beans75734692be_an_s
beasts84519722be_asts
beats76042242be_a_ts
beauts86015282be_auts
bents76033692be__nts
bepaints1235112bepaints
bezzant1746892bezzant_
brants85723052b_rants
byzant2096812byzant_
decants103514442decants
gelants82611442gelants
levants1037722levants
pedants10310112pedants
recants93217092recants
secants93413892secants
tenants7311012tenants
aberrants1145853aberrants
abeyant1248083abeyant_
alants67722023_alants
ants47243473___ants
azans146516883_azan_s
bahts105617803b__ahts
baits76630583b__aits
bananas93312223bananas
bands85233423b__ands
banes74945583b__anes
bangs85627773b__angs
banks115527903b__anks
banns75321233b__anns
bans66555143b__an_s
banty106624003b__anty
basalts9358963basalts
basts75936933b__asts
bats66962333b__a_ts
batts76727563b__atts
bazaars18275883bazaars
bazars174613113baza_rs
beads85429503be_a_ds
beaks115326623be_a_ks
beams95328173be_a_ms
bean66443863be_an__
beaned95621473be_aned
beanie83618593be_anie
beanies93821093be_anies
beano75421553be_an_o
beards94116673be_ards
bears75739043be_a_rs
beast76338643be_ast_
beat66168303be_a_t_
beaus75127113be_a_us
beaut75135213be_aut_
beauty115410163be_auty
becalms1335743becalms
becaps123811403beca_ps
beckets15399823beckets
bedamns1235733bedamns
bedaubs1233693bedaubs
bedpans1237173bedpan_s
bedsits1037563bedsits
beets76131443be__ets
befalls12349123befalls
befits114711503be_fits
befrets1237613befrets
begalls10319163begalls
began86319573began__
begat86629723bega_t_
begazes1937963begazes
begets96215523be_gets
begins94415303begin_s
behaves15198523behaves
behests1235953behests
behinds1335283behinds
beignes10149243beignes
beignets11155373beignets
beings94613033be_ings
beknots1335083beknots
belauds1036643belauds
belays114313853bela_ys
belongs10408223belongs
belons84119413belon_s
belts75931163be__lts
bemas96424283bema__s
bemata10411693bema_ta
bemeans1148743bemean_s
bemists113410703bemists
bemoans1138253bemoan_s
benames112814603benames
bends85628973be__nds
benes75536233be__nes
bennes86019013be_nnes
bennets94712163bennets
bennis84314803be_nnis
bens65945703be__n_s
bent67759913be__nt_
bento75922953be__nto
bentos86218303be__ntos
benzenes1946853benzenes
benzines1938213benzines
benzins1838693benzin_s
bepaint11312183bepaint_
berakes134815773berakes
berate84729023bera_te
berates94126873berates
berets85822523be_rets
besets85718803be_sets
besmuts1134683besmuts
besots86415453be_sots
bests75932613be__sts
betaines10313293betaines
betakes134212523betakes
betas75528763beta__s
bethanks1765313bethanks
betons84919553beton_s
bets67051443be___ts
bewails1277553bewails
bewares12313373bewares
beyonds1335063beyonds
bezazz1543983beza_zz
bezazzes1741983bezazzes
bezels173712283bez_els
bezils1711310603bez_ils
bezoars1836793bezoars
bhangs12449663b_hangs
bints76130183b__ints
bionts8612393b_ionts
bizones1837823bizones
blanks124112893b_lanks
blasts85116773b_lasts
blats75132503b_la_ts
bleats85518613blea_ts
bloats85215763bloa_ts
blunts84512893b_lunts
boarts84716873b_oarts
boasts85017923b_oasts
boats75635153b_oa_ts
bogans95714813bogan_s
bogarts1047743bogarts
boranes93720403boranes
bracts105617773b_racts
brands95118943b_rands
branks124817383b_ranks
brans75437433b_ran_s
brant74742173b_rant_
brats75336013b_ra_ts
breasts939703breasts
brents84717273b_rents
brunts85215453b_runts
bunts75729803b__unts
burans85019303buran_s
butanes9312743butanes
bwanas1157443b_wanas
cants77036943__cants
cements112714223cements
cents74730333ce__nts
cetanes9315133cetanes
chants115020393_chants
deans66131393de_an_s
decanes103118913decanes
decant93524223decant_
dedans85915073dedan_s
defangs1235363defangs
defats105114553defa_ts
demands114311413demands
demasts1089223demasts
dements103016623dements
dents65031803de__nts
depaints1136643depaints
departs104310683departs
derats74625063dera_ts
desalts839573desalts
desands94810163desands
descants112910143descants
detents83615153detents
deviants1236733deviants
dewans105215143dewan_s
dezincs1933753dezincs
dopants1038433dopants
easts57530323_e_asts
eats47054873_e_a_ts
elands74914773_elands
elans55527753_elan_s
elints65816423_elints
eluants737583eluants
enacts84012973_enacts
epacts105010393_epacts
errants7410643errants
events94814073_events
exacts15359613_exacts
exalts13328313_exalts
feasts95116093fe_asts
feats86432753fe_a_ts
feints94813873fe_ints
gelant72821673gelant_
gellants9308283gellants
gents65729613ge__nts
gerents82612923gerents
giants74713503_giants
grants73722473_grants
hants86335403__hants
hazans183411653hazan_s
hearts96218943he_arts
heats85838403he_a_ts
hents87330743he__nts
hexanes17319463hexanes
incants92012803incants
infants102210773infants
jeans126022113je_an_s
jezails2334163jezails
jurants14379213jurants
leans55536253le_an_s
leant56737783le_ant_
leasts64616413le_asts
lemans85316393leman_s
levant9314493levant_
libelants1145303libelants
means75831233me_an_s
meant76537213me_ant_
meats75034053me_a_ts
mediants11299493mediants
mutants938583mutants
neats55931903ne_a_ts
octants9128733octants
operants1039483operants
pants76536923__pants
peans75437643pe_an_s
peanuts936993pe_anuts
peasants1038263peasants
peats76140193pe_a_ts
pecans101515833pecan_s
pedant9319493pedant_
pekans121710553pekan_s
penangs10268373penangs
pendants1139093pendants
pennants1037063pennants
plants84921803_plants
quants153614143_quants
rants55935343__rants
reacts83616603re_acts
rebaits9312573rebaits
recanes93222263recanes
recant83228683recant_
recasts93413533recasts
redacts10510943redacts
redans75421023redan_s
regents83416543regents
regrants9310013regrants
rehangs1137563rehangs
relands85214883relands
relents74018503relents
remands104914883remands
remans84823003reman_s
remints95117293remints
remnants1036843remnants
rents55935183re__nts
repaints1038483repaints
repasts93611933repasts
repents93717623repents
replants102811243replants
rerents73319423rerents
resents74221223resents
retints74717013retints
rezones163213943rezones
savants1038653savants
scants85219723_scants
sealants82610743sealants
seats54844343se_a_ts
seawants11337973seawants
secant84023293secant_
sedans74816093sedan_s
sejant133114483sejant_
servants1138003servants
sewans95215903sewan_s
sextants15287383sextants
slants64819083_slants
sonants7511233sonants
teats55636813te_a_ts
tenant6322473tenant_
tents56434213te__nts
tetanus737933tetanus
truants738163truants
tyrants1037453tyrants
vegans103910853vegan_s
vents86125933ve__nts
versants1137783versants
wants87932213__wants
weans85326743we_an_s
weazands2143333weazands
yeans86624883ye_an_s
yeasts96413053ye_asts
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 Filter1786911340270.406440125.6
2DLD Change Limit1340272955.89322743.4
3Display Results2952950.0933172.0
 (SQL Overall)1786912956.39227955.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.