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

199 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
barbell1142996(None) 
barbel104317071barbe_l
barbells12368821barbells
barbels114514431barbels
babel95821692ba_be_l
babels105216722ba_bels
barbal104016662barb_al
barbe95328282barbe__
barbed115121312barbe_d
barber104419322barbe_r
barbers114317502barbers
barbes104526232barbe_s
barbet104427882barbe_t
barbets114915842barbets
barbule1137942barbule
barely114716792bar_ely
bargello1144142bargello
barrel84517872barre_l
barrels94514362barrels
carrell94610462carrell
harebell1344352harebell
abele76323253_a_bele
areal55928733_ar_eal
argyll1033643_argyll
ariel55228973_arie_l
ariels65119373_ariels
artel56122743_arte_l
artels66216233_artels
babble94017113ba_bble
babbled113612863babbled
babbler104012823babbler
babbles104416323babbles
babe86835813ba_be__
babes95834113ba_be_s
babool103012153ba_bool
babul96317713ba_b_ul
babuls105413643ba_buls
bagel85116793ba_ge_l
bagels95712313ba_gels
ball66043323ba___ll
balneal936573balneal
barb85240063barb___
barbate11314543barbate
barbecue14194703barbecue
barbeque21134063barbeque
barbered13259543barbered
barberry1544853barberry
barbette1249113barbette
barbicel14144963barbicel
barbicels15113513barbicels
barbie105018353barb_ie
barbies114519593barbies
barbing123716993barbing
barbital1247053barbital
barbless12318713barbless
barbs95928193barb__s
barbules1238043barbules
barbut104617003barb_ut
barbuts11439843barbuts
barde85330773barde__
barded105426423barde_d
bardes95026933barde_s
bare65460523bar_e__
bared85144483bar_e_d
barege94713543bar_ege
barer74535803bar_e_r
bares75457133bar_e_s
barest85327693bar_est
barfed125416383barfe_d
barfly14339653bar_fly
barge85631023barge__
barged105822643barge_d
bargee94624443barge_e
bargees105415873bargees
bargellos1243323bargellos
barges94528253barge_s
barilla9310323barilla
barked135027313barke_d
barkeep1536363barkeep
barker124822863barke_r
barkers134318513barkers
barless94317003barless
barley115116763barle_y
barleys125011843barleys
barmen105418533barme_n
barned95623583barne_d
barney115314453barne_y
barneys12569563barneys
barre75929543barre__
barred95725793barre_d
barreled1137843barreled
barrelful1442313barrelful
barrelled1245253barrelled
barren85317613barre_n
barrenly1345413barrenly
barrens94414323barrens
barres84427543barre_s
barret84930483barre_t
barrets94917103barrets
bartend1038753bartend
barter85525373barte_r
barters94223033barters
barye105021493barye__
baryes116218503barye_s
baseball1245623baseball
basely114412313ba_sely
baubee103215993baube_e
baubees11348713baubees
bauble103813213baub_le
baubles113611863baubles
bawbee132714233bawbe_e
bawbees14337243bawbees
beanball1264673beanball
bedell93610043b_edell
befell11428713b_efell
bell66237183___bell
bluebell1243533bluebell
boatbill1244463boatbill
bordel94514573borde_l
bordello1144713bordello
bordels103911973bordels
boreal84817213bor_eal
borneol936823borneol
boxball18155323boxball
brabble10349973brabble
bravely15428233bravely
brill74819953b_r_ill
bulbel104510683bulbe_l
bulbels11398013bulbels
burble104617703burb_le
burbled124312673burbled
burbler114412423burbler
burbles114916803burbles
burbly134311153burb_ly
carcel105018673carce_l
carcels114516063carcels
carpel105418473carpe_l
carpels115315463carpels
carrel84718633carre_l
carrells10359263carrells
carrels95117303carrels
cartel85022533carte_l
cartels94618123cartels
carvel114817573carve_l
carvels124914593carvels
corbeil11859213corbeil
corbel103715973corbe_l
corbels113813593corbels
cowbell1445223cowbell
darnel74312183darne_l
darnels83710433darnels
doorbell1143403doorbell
fardel104712593farde_l
fardels11389893fardels
farewell1443313farewell
farfel124310433farfe_l
farfels13348213farfels
gabelle10259213ga_belle
garbed104815663garbe_d
garble94118453garb_le
garbled114512803garbled
garbler104012563garbler
garbles104016923garbles
garboil1036513garboil
gorbelly1445453gorbelly
hairball1344633hairball
handbell14114523handbell
hardball14116303hardball
harebells1444193harebells
label75019383la_be_l
labella988943la_bella
labels84515683la_bels
largely1136703largely
marble104219103marb_le
marbled123212113marbled
marbler113511673marbler
marbles114516653marbles
marbly134111933marb_ly
marcel103714853marce_l
marcels113212373marcels
martello1045093martello
marvel113712003marve_l
marvels123810093marvels
maxwell1942513maxwell
parboil1138323parboil
parcel103915473parce_l
parcels113712663parcels
parrel84515983parre_l
parrels94713493parrels
rarely93513653rar_ely
sawbill1255293sawbill
tramell9398703tramell
warble113516603warb_le
warbled133212163warbled
warbler123211463warbler
warbles123215563warbles
waxbill1943133waxbill
waybill1543723waybill
yarely122810303yar_ely

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.1561145455.1
2DLD Change Limit1340271997.43618024.1
3Display Results1991990.0802487.5
 (SQL Overall)1786911997.67223291.3
 
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.