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

217 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
barbule113794(None) 
barbules1238041barbules
arbute8311042_arbute
babble94017112ba_bble
babul96317712ba_bul_
babuls105413642ba_buls
barbal104016662barbal_
barbate11314542barbate
barbe95328282barb__e
barbel104317072barbel_
barbell11429962barbell
barbels114514432barbels
barbie105018352barb_ie
barbut104617002barbu_t
barbuts11439842barbuts
barque17239552barqu_e
bascule1136572bascule
bauble103813212baub_le
brabble10349972brabble
burble104617702burb_le
garble94118452garb_le
marble104219102marb_le
warble113516602warb_le
abele76323253_a_bele
able66340533_a_b_le
abubble1044523abubble
abuse77119563_a_buse
amble95924633_amb_le
ampule10710613_ampule
arable81821003_arable
arbuscle1242883_arbuscle
arbutes939703_arbutes
areole61017283_areole
argle65421563_ar_gle
argue64818443_argu_e
argyle1066063_argyle
armure8710133_armure
arouse65019983_arouse
babbled113612863ba_bbled
babbler104012823ba_bbler
babbles104416323ba_bbles
babe86835813ba_b__e
babel95821693ba_bel_
babels105216723ba_bels
babu85829223ba_bu__
babus95620333ba_bu_s
bacula103112673ba_cula
baffle14399873ba_ffle
bagful1237213bagful_
bagfuls1334753bagfuls
bale66353843ba___le
ballute938543ballute
bangle94018953ba_ngle
barb85240063barb___
barbecue14194703barbecue
barbed115121313barb_ed
barbells12368823barbells
barbeque21134063barbeque
barber104419323barb_er
barbered13259543barbered
barbers114317503barbers
barbes104526233barb_es
barbet104427883barb_et
barbets114915843barbets
barbette1249113barbette
barbicel14144963barbicel
barbies114519593barbies
barbing123716993barbing
barbless12318713barb_less
barbs95928193barb__s
barbwire1543863barbwire
barde85330773bar__de
bare65460523bar___e
barege94713543bar_ege
barely114716793bar_ely
barfly14339653bar_fly
barge85631023bar__ge
bargee94624443bar_gee
barilla9310323barilla
barite84224813bar_ite
barium10313513bariu_m
bariums1139143bariums
barley115116763bar__ley
barmie103816393bar_mie
barnacle1245943barnacle
baronne938263baronne
baroque1835103baroque
barouche1544173barouche
barques18259643barques
barrable1249243barrable
barrage10710843barrage
barre75929543bar__re
barrel84517873barrel_
barreled1137843barreled
barrels94514363barrels
barware12610703barware
barye105021493bar__ye
baryte115312883bar_yte
bascules1236683bascules
basque17259083basqu_e
bastile9313913bastile
battle85217863ba_ttle
battue84311003battu_e
baubee103215993baub_ee
baubles113611863baub_les
baulk114914333ba__ulk
bawbee132714233bawb_ee
bearable121512363bearable
bible95119413b_ib_le
birle75023633bir__le
bobble94115143b_obble
bordure1035773bordure
boule74828043b__oule
brabbled12337633brabbled
brabbler11397373brabbler
brabbles11349753brabbles
braille939713braille
bramble133710033bramble
brattle9249253brattle
bravure1254393bravure
bridle94115463b_ridle
brume95817983b_r_ume
brute75321783b_r_ute
bubale104014623b_ubale
bubble94016593b_ubble
bulbul10348073bulbul_
bulbuls11346783bulbuls
bumble124216893bumb_le
burbled124312673burb_led
burbler114412423burb_ler
burbles114916803burb_les
burbly134311153burb_ly
burgle94815863bur_gle
cable95329913ca_b_le
capsule1137343capsule
carbide126112493carbide
carbine112918643carbine
carbuncle1543083carbuncle
carburet12411103carburet
carful11610973carful_
carfuls1249133carfuls
cariole9818343cariole
carle74535703car__le
carouse9614423carouse
carpale113414353carpale
curule83614123cur_ule
dabble114515193da_bble
dariole8711163dariole
darkle113813943dar_kle
dartle73714833dar_tle
drabble12238883drabble
earbud936283earbu_d
earbuds1044633earbuds
earful958963earful_
earfuls1036863earfuls
fable105824753fa_b_le
farle86929243far__le
ferrule1035863ferrule
ferule93413203fer_ule
gabble113815723ga_bble
gable85325523ga_b_le
gamble115417183gamb_le
garbage1138053garbage
garbled114512803garb_led
garbler104012563garb_ler
garbles104016923garb_les
gargle84215463gar_gle
globule1034383globule
grabble12339643grabble
granule839473granule
habile11515203ha_bile
jarful1646683jarful_
jarfuls1754773jarfuls
labile8315213la_bile
lobule82910063_lobule
macule104115273ma_cule
marbled123212113marb_led
marbler113511673marb_ler
marbles114516653marb_les
marbly134111933marb_ly
marque172410503marqu_e
marquee18218583marquee
nargile847653nargile
nebule848753_nebule
nervule1044943nervule
papule102212133pa_pule
parable111819773parable
parbake1538353parbake
parbuckle1942103parbuckle
parle75836163par__le
parole84425253par_ole
parure8312523par_ure
rabble103818243ra_bble
ramble104519973ramb_le
ruble74521253__ruble
rule49938423__r_ule
sable74732163sa_b_le
saccule1136743saccule
sambuke1544203sambuke
subrule939643subrule
table75429603ta_b_le
tabuli839363ta_buli
tarbush1234173tarbush
tartufe1064673tartufe
tubule839853_tubule
valvule1343663valvule
variole10711593variole
verbile1249863verbile
virgule1144283virgule
wabble133714843wa_bble
wamble134415753wamb_le
warbled133212163warb_led
warbler123211463warb_ler
warbles123215563warb_les
warsle93112923war_sle
warstle10328013warstle
yarmulke1741483yarmulke

Search took 9 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 Limit1340272177.81317154.4
3Display Results2172170.0802712.5
 (SQL Overall)1786912178.04922200.4
 
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.