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

202 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
bartends113679(None) 
bartend1038751bartend_
attends8257592_attends
bantengs1134592bantengs
barrens94414322barren_s
bartended1344662bartended
bartender1244602bartender
bartenders1344222bartenders
barters94223032barte_rs
battens95313262batten_s
martens93714952marten_s
portends11358962portends
addends10356053_addends
amends94713283_a_mends
appends1236393_appends
arenas65021993_ar_enas
arenes64928393_ar_enes
argents84014853_argents
arpens84814823_arpen_s
arpents93613083_arpents
artels66216233_arte_ls
ascends10388203_ascends
attend7258973_attend_
augends935883_augends
backbends2044093backbends
badlands1236673badlands
baited95319243baite_d_
baiters94619303baite_rs
baleens938473baleen_s
bands85233423ba___nds
banteng1046363banten_g
banters94623113bante_rs
barbed115121313barbe_d_
barbells12368823barbells
barbels114514433barbe_ls
barbers114317503barbe_rs
barbes104526233barbe__s
barbets114915843barbe_ts
barded105426423barde_d_
bardes95026933barde__s
bards87139643bar___ds
bared85144483bar_e_d_
bareges105212033bar_eges
barehands1545253barehands
bareness10912813bar_eness
bares75457133bar_e__s
barfed125416383barfe_d_
barged105822643barge_d_
bargees105415873barge_es
barges94528253barge__s
barites94322333barite__s
baritones1158943baritones
barked135027313barke_d_
barkeeps1634143barkeeps
barkers134318513barke_rs
barless94317003barle_ss
barleys125011843barle_ys
barmaids1345943barmaids
barmen105418533barmen__
barned95623583barne_d_
barneys12569563barne_ys
barns76335143bar__n_s
baroness101210063baroness
baronets101410903baronets
barongs105310833bar_ongs
baronnes1038553baronnes
barons85025383bar_on_s
barred95725793barre_d_
barrels94514363barre_ls
barren85317613barren__
barrener1038333barrener
barrenest1149563barrenest
barrenly1345423barrenly
barres84427543barre__s
barrets94917103barre_ts
bartending1444913bartending
barter85525373barte__r
bartered113113013bartered
barterer102711633barterer
barterers11269633barterers
baryes116218503barye__s
baryons121010473baryon_s
barytes124611153baryte__s
barytones1455563barytones
barytons1345573baryton_s
bastards113310313bastards
basted95227233baste_d_
basters94930303baste_rs
bastes85330383baste__s
bastings114214693bastings
bated85935533ba_te_d_
bates75846343ba_te__s
batons85519423ba_ton_s
batted95623653batte_d_
batten85217123batten__
battened11259573battened
battener10369393battener
batteners11238163batteners
batters94626013batte_rs
battings114010573battings
befriends1542413befriends
bends85628973b___ends
besteads11307123besteads
blends96012883b__lends
bookends15374853bookends
boreens9310403boreen_s
brands95118943b_r_ands
brazens18418713brazen_s
breads95419203b_r_eads
breeds94914883b_r_eeds
brens75823363b_r_en_s
brents84717273b_r_ents
burdens1039713burden_s
burseeds1134783burseeds
burthens1335383burthen_s
burtons9310853burton_s
burweeds1434103burweeds
butenes9313033b_utenes
calends1039523ca_lends
careens94514703careen_s
carotenes11410203carotenes
carted98631443carte_d_
cartels94618123carte_ls
carters95327253carte_rs
cartes86239473carte__s
cartons94122473carton_s
catenas9313113ca_tenas
coattends1243913coattends
contends112810573contends
darkens12409873darken_s
darted84620923darte_d_
darters84017603darte_rs
distends10339823distends
extends15227113_extends
faciends1443573faciends
farted105121783farte_d_
fastens105511753fasten_s
fattens105111713fatten_s
forfends1544833forfends
friends11396743_friends
gardens93312093garden_s
garlands1038323garlands
garments1139963garments
garters84218233garte_rs
haptenes133810823haptenes
haptens124511343hapten_s
hardens113815023harden_s
harkens144112863harken_s
hastens106214813hasten_s
hatreds11307813hatre_ds
heartens113010153hearten_s
intends8239963_intends
jarheads1944793jarheads
kalends1235683ka_lends
kartings13418523kartings
lagends947273la_gends
latens64620213la_ten_s
latents75214313la_tents
lattens75014673latten_s
malteds10377603malte_ds
margents11410133margents
marted94425213marte_d_
marten84518263marten__
martinis103311613martinis
martins93322063martin_s
mistends11419593mistends
parents93418123par_ents
partans94418283partan_s
parted94228683parte_d_
partings113513733partings
partners102711133partners
partons94620513parton_s
parvenus1335653parvenus
patens84820863pa_ten_s
patents94815203pa_tents
pattens95414923patten_s
perpends13227753perpends
portend103411193portend_
portents103512823portents
pretends11299113pretends
protends113010353protends
rattens74213403ratten_s
rends65129953__r_ends
sarments10311963sarments
sarsens7311393sarsen_s
smartens10286663smarten_s
subtends1136173subtends
tartanas8258893tartanas
tartans72615823tartan_s
tarted74923373tarte_d_
tartness82210133tartness
tarweeds1244273tarweeds
tautens7317843tauten_s
tends65425583___tends
trends75513543_tr_ends
uptrends1142833uptrends
varments1339063varments
wardens113711903warden_s
warheads1545853warheads
warrens103810893warren_s
warted104223233warte_d_
yearends12234483year_ends

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622026.89021213.6
3Display Results2022020.0762657.9
 (SQL Overall)1786912027.38924183.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.