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

521 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
bartend103875(None) 
bartends1136791bartends
attend7258972_attend
baited95319242baite_d
banteng1046362banteng
barbed115121312barbe_d
barded105426422barde_d
bared85144482bar_e_d
barfed125416382barfe_d
barged105822642barge_d
barked135027312barke_d
barmen105418532barmen_
barned95623582barne_d
barred95725802barre_d
barren85317622barren_
barrens94414322barrens
bartended1344672bartended
bartender1244612bartender
barter85525382barte_r
bartered113113032bartered
barters94223052barters
basted95227232baste_d
bated85935532ba_te_d
batted95623652batte_d
batten85217122batten_
battened11259572battened
battens95313262battens
carted98631442carte_d
darted84620922darte_d
farted105121782farte_d
marted94425212marte_d
marten84518262marten_
martens93714952martens
parted94228682parte_d
portend103411192portend
tarted74923372tarte_d
warted104223232warte_d
abated95918453abate_d
aborted10310423aborte_d
acted88521733_acte_d
addend9458453_addend
airted74214503airte_d
amend85717753_a_mend
anted66328243_ante_d
anteed75616113_anteed
append1138273_append
arced88224163_arce_d
ardent73022613_ardent
arena55323813_ar_ena
arene55329413_ar_ene
argent74023663_argent
armed86324433_arme_d
around72712413_around
arpen74418043_arpen_
arpens84814823_arpens
arpent84822093_arpent
arseno6318913_arseno
artel56122743_arte_l
artels66216233_artels
artery9911453_artery
ascend9429733_ascend
attends8257593_attends
attent62818323_attent
augend837633_augend
baaed85218163ba_ae_d
babied114913513babie_d
bached145519893bache_d
backbend1944783backbend
backed155725723backe_d
badged114814793badge_d
badland1147653badland
badmen114613833badmen_
baffed154812173baffe_d
bagged114519903bagge_d
bagmen115412533bagmen_
bailed94726653baile_d
baiter84422563baite_r
baiters94619313baiters
baiting103918883baiting
baked126130773ba_ke_d
balded105417513balde_d
baled85436443ba_le_d
baleen8613053baleen_
baleens938473baleens
balked135219413balke_d
balled94926893balle_d
bammed133913243bamme_d
band76740923ba___nd
banded105223173bande_d
baned85436353ba_ne_d
banged104923733bange_d
banked135021443banke_d
banned94721343banne_d
bantengs1134593bantengs
banter84825343bante_r
bantered113313653bantered
banters94623123banters
barbe95328283barbe__
barbel104317073barbe_l
barbell11429963barbell
barbels114514433barbels
barber104419323barbe_r
barbered13259553barbered
barbers114317503barbers
barbes104526233barbe_s
barbet104427883barbe_t
barbets114915843barbets
barbing123716993barbing
bard75648863bar___d
barde85330773barde__
bardes95026933barde_s
barding113822893barding
bare65460523bar_e__
barege94713543bar_ege
barehand1446153barehand
barehead1446603barehead
barely114716793bar_ely
barer74535803bar_e_r
bares75457133bar_e_s
barest85327693bar_est
barfing134615093barfing
barge85631023barge__
bargee94624453barge_e
bargees105415873bargees
barges94528253barge_s
barging114018483barging
baring95135853bar_ing
barite84224813barite__
barites94322333barite_s
baritone1058643baritone
barkeep1536363barkeep
barker124822863barke_r
barkers134318513barkers
barking144724183barking
barless94317003barless
barley115116763barle_y
barleys125011843barleys
barmaid1238203barmaid
barman103519713barman_
barn66444643bar__n_
barney115314453barne_y
barneys12569563barneys
barning104320353barning
barns76335143bar__ns
barny105821733bar__ny
baron78131243bar_on_
baronet91022213baronet
barong96015823bar_ong
baronne938273baronne
barons85025383bar_ons
barony115915303bar_ony
barre75929553barre__
barrel84517883barre_l
barreled1137853barreled
barrels94514363barrels
barrener1038343barrener
barrenly1345423barrenly
barres84427553barre_s
barret84930493barre_t
barrets94917103barrets
barring104021593barring
bartenders1344243bartenders
bartending1444913bartending
barterer102711653barterer
bartering122313653bartering
barye105021493barye__
baryes116218503barye_s
baryon111211613baryon_
baryons121010473baryons
baryte115312883baryte__
barytes124611153baryte_s
baryton1246003baryton_
barytone1356023barytone
barytons1345573barytons
based85331583ba_se_d
bashed126225703bashe_d
basined10310003basined
basked135218603baske_d
bastard103012423bastard
baste74829983baste__
baster85333603baste_r
basters94930313basters
bastes85330383baste_s
basting104227203basting
bate66552423ba_te__
bateau8810573ba_teau
bates75846343ba_te_s
bathed125518743ba_thed
bating95132253ba_ting
batmen104414303batmen_
baton75822423ba_ton_
batons85519423ba_tons
batteau936353batteau
battener10369403battener
batter84928883batte_r
battered113315073battered
batters94626023batters
battery124911823battery
batting104422273batting
battled104213123battled
bausond1044493bausond
bawled124415693bawle_d
bayed115423023ba_ye_d
baymen134212003baymen_
bearded114212133bearde_d
beaten84617063beaten_
befriend1443263befriend
belted94020633belte_d
bend76435263b___end
berated104422133berate_d
bermed115217723berme_d
berthed13259123berthed
bestead10389123bestead
bested94922763beste_d
betted94721163bette_d
biparted1335133biparte_d
birded104414303birde_d
birled94416993birle_d
birred94713203birre_d
birthed13228593birthed
bitted94418483bitte_d
bitten84715123bitten_
blared95018243blar_e_d
blasted104213473blaste_d
blatted104812713blatte_d
blend85317453b__lend
blurted10399783blurte_d
boarded113910503boarde_d
boasted104113743boaste_d
boated94221973boate_d
bogarted1235053bogarte_d
bolted94617803bolte_d
bookend14396643bookend
booted94822733boote_d
borated104116363borate_d
bored85034303bor_e_d
boreen8314313boreen_
boreens9310403boreens
borked135117293borke_d
braced115420603brace_d
bracted12410933bracte_d
brained103816103brained
braked135318693brake_d
brand85124493b_r_and
branned104311693branned
braved124817443brave_d
brayed124615783braye_d
brazed184717083braze_d
brazen174812453brazen_
brazened20134903brazened
brazens18418713brazens
bread85523113b_r_ead
bred75130973b_r_e_d
breed85526693b_r_eed
bren65629563b_r_en_
brens75823363b_r_ens
brent75734133b_r_ent
brined95118413b_rined
bruted95113263brute_d
bunted95219183bunte_d
burden9412473burden_
burdened1236423burdened
burdens1039713burdens
buried94822373burie_d
burked135220883burke_d
burled94825383burle_d
burned95818963burne_d
burped116215503burpe_d
burred95820723burre_d
burseed1049503burseed
bursted1039423burste_d
burthen1236363burthen_
burthened1543963burthened
burthens1335383burthens
burton8311273burton_
burtons9310853burtons
burweed1347823burweed
busted95123153buste_d
butene8312623b_utene
butted94722063butte_d
byrled12437173byrle_d
canted94825783cante_d
carded105424903carde_d
cared86050093car_e_d
careen84119493careen_
careened1139193careened
careens94514703careens
caried94528693carie_d
carked134024823carke_d
carmen104019343carmen_
carotene1039133carotene
carped115923763carpe_d
carte75940423carte__
cartel85022533carte_l
cartels94618123cartels
carter84932273carte_r
carters95327263carters
cartes86239473carte_s
carting104228283carting
carton84522663carton_
cartoned111312833cartoned
cartons94122473cartons
carved124320853carve_d
carven114716663carven_
catena8312483ca_tena
catted95422473catte_d
charted135116853charte_d
coattend1134653coattend
contend103511893contend
crated94827773crate_d
dared75935013dar_e_d
darked123919633darke_d
darken114013443darken_
darkened1435943darkened
darkens12409873darkens
darned85018483darne_d
darter75320363darte_r
darters84017613darters
darting94020663darting
dartled9409853dartled
dated75530993da_te_d
dauted84114933daute_d
dawted11489683dawte_d
distend93312073distend
eared65139503ear_e_d
earned74818333earne_d
earthed1139923earthed
earthen1039253earthen_
eaten55323053ea_ten_
extend14267523_extend
faciend1334803faciend
farced125216533farce_d
farded114518953farde_d
fared95842343far_e_d
farmed125117653farme_d
farting114120753farting
fasted105320953faste_d
fasten95114893fasten_
fastened12257853fastened
fastens105511753fastens
fated95632133fa_te_d
fatted105419843fatte_d
fatten94314903fatten_
fattened12268283fattened
fattens105111713fattens
forfend1435413forfend
friend10388933_friend
gaited84416923gaite_d
garbed104815663garbe_d
garden84215083garden_
gardened1137003gardened
gardens93312093gardens
garland948703garland
garment10315233garment
garoted9710133garote_d
garred85217413garre_d
garter74420513garte_r
gartered10319603gartered
garters84218253garters
gasted84821583gaste_d
gated75329773ga_te_d
girted83912873girte_d
grated84523923grate_d
hafted134713833hafte_d
halted105019603halte_d
hanted104124313hante_d
hapten115312983hapten_
haptene123810933haptene
haptens124511343haptens
harden105718533harden_
hardened1338613hardened
hardens113815023hardens
hared95742183har_e_d
harked145422553harke_d
harken135116343harken_
harkened1637483harkened
harkens144112863harkens
harmed125218833harme_d
harped124418403harpe_d
hasted105125283haste_d
hasten95718563hasten_
hastened12239103hastened
hastens106214813hastens
hated95734023ha_te_d
hatred104814333hatre_d
hatted104921513hatte_d
hearted113314033hearte_d
hearten102411763hearten_
heartened1347083heartened
heartens113010153heartens
intend72310373_intend
jarhead1835173jarhead
jarred144613253jarre_d
karting123716063karting
lagend838743la_gend
larceny1234853larceny
larded84319093larde_d
larked114519473larke_d
lasted74323603laste_d
lated65240673la_te_d
laten54328343la_ten_
latened8711923la_tened
latens64620213la_tens
latent64124303la_tent
latten65018203latten_
lattens75014673lattens
malted94819863malte_d
margent10316693margent
marked133921623marke_d
marled95523163marle_d
marred95421043marre_d
martin84122523martin_
marting103325013marting
martini93613873martini
martins93322063martins
masted94025803maste_d
mated85537783ma_te_d
matted94521413matte_d
mistend103812523mistend
narked114116743narke_d
oared65030653oar_e_d
oaten55222403oa_ten_
orated74221503orate_d
panted95024823pante_d
pared86946763par_e_d
parent83230423par_ent
parged104922043parge_d
parked134425143parke_d
parled94626293parle_d
parred95024073parre_d
parsed96323893parse_d
partan83820563partan_
partans94418283partans
partied103516553partied
parting103527383parting
partner92811393partner
parton84720993parton_
partons94620513partons
parvenu1247023parvenu
pasted94426903paste_d
pated85237843pa_te_d
paten74827343pa_ten_
patens84820863pa_tens
patent84524923pa_tent
patted94724683patte_d
patten84418193patten_
pattened11299393pattened
pattens95414923pattens
perpend12259353perpend
ported94223243porte_d
portends11358963portends
portent93619643portent
prated94924923prate_d
pretend104011013pretend
protend104012793protend
rafted104714703rafte_d
ranted74324703rante_d
rared65738323rar_e_d
rated65441383ra_te_d
ratted74923343ratte_d
ratten64217383ratten_
rattened9218623rattened
rattens74213403rattens
rend56136573__r_end
salted74121203salte_d
sarment9318763sarment
sarsen6314233sarsen_
sarsens7311393sarsens
sated66238533sa_te_d
sauted74119603saute_d
sauteed8349613sauteed
scarted104816123scarte_d
smarted105012613smarte_d
smarten9348863smarten_
smartened1244273smartened
smartens10286663smartens
sorted74523713sorte_d
started84217323starte_d
subtend1037103subtend
tared69340053tar_e_d
tarred74720283tarre_d
tartan64217513tartan_
tartana73010193tartana
tartans72615823tartans
tarter64023563tarte_r
tartest72517533tartest
tarting84222653tarting
tarweed1137343tarweed
tasted74123973taste_d
tatted74920533tatte_d
tauted75317113taute_d
tauten64311893tauten_
tautened935423tautened
tautens7317843tautens
tend56433773___tend
torten65314353torten_
trend64817453_tr_end
uptrend1044293uptrend
varied104817863varie_d
varment12313243varment
varved134110603varve_d
vatted104214733vatte_d
wafted134012143wafte_d
waited103819773waite_d
wanted104319723wante_d
warded115021043warde_d
warden104515513warden_
wardens113711903wardens
wared96339873war_e_d
warhead1436603warhead
warked144421213warke_d
warmed124516893warme_d
warned104018913warne_d
warped124816413warpe_d
warred104019853warre_d
warren95012863warren_
warrens103810893warrens
wasted104423023waste_d
yarded114714023yarde_d
yarned105514023yarne_d
yearend11285703year_end

Search took 8 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.390458182.1
2DLD Change Limit1340275216.81319672.2
3Display Results5215210.1862801.1
 (SQL Overall)1786915217.38924183.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.