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

213 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
barrable124924(None) 
arable81821002_a_rable
bailable1238582bailable
bankable1677912bankable
bannable1278352bannable
barnacle1245942barnacle
barrage10710842barra_ge
bearable121512362bearable
boardable1444892boardable
burnable1237262burnable
cartable121314092cartable
errable9312182_errable
farmable1538202farmable
parable111819772pa_rable
parsable12311692parsable
variable13310062variable
abatable1238023abatable
abradable1495063abradable
abrogable1444573abrogable
abusable1236373abusable
actable11313473_actable
addable11218843_addable
adorable1138773adorable
affable15117403_affable
alarmable1345013alarmable
amiable11312033_amiable
arables91814973_a_rables
arguable1135903_arguable
arrange838683_arrange
averrable14105413averrable
awardable1543953awardable
babble94017113ba__bble
barbal104016663barba_l_
barbate11314543barba_te
barbe95328283ba_r_b_e
barbel104317073ba_r_bel
barbie105018353ba_r_bie
barbule1137943ba_rbule
barcarole1343773barcarole
barnacled1444003barnacled
barnacles1355333barnacles
barrack1538253barra_ck
barracked1844753barracked
barracker1744653barracker
barracks1636883barracks
barraged1297683barraged
barrages11711083barrages
barranca1245583barranca
barranco1244943barranco
barrater10310143barrater
barrator1048403barrator
barratry13114473barratry
barre75929543barr___e
barrel84517873barr_el_
barreled1137843barr_eled
barrelled1245253barrelled
barrels94514363barr_els
barrenly1345423barrenly
barrette1039783barrette
barware12610703barwa_re
bauble103813213ba__uble
bearably15177933bearably
beatable121612243beatable
beddable14166923beddable
bendable131510853bendable
biddable14165673biddable
billable12179503billable
bindable13169623bindable
bitable11312203b_itable
biteable1237933biteable
blamable1436693blamable
blameable1544723blameable
boatable121610263boatable
boilable1237793boilable
bombable1336263bombable
bondable13169273bondable
bookable16127003bookable
bootable12179223bootable
brabble10349973b_rabble
bramble133710033b_ramble
bribable1137223bribable
buffable1844393buffable
burble104617703b_ur_ble
burnables1344003burnables
buyable1437493b_uyable
callable12310753callable
capable13313363ca_pable
carpale113414353carpa_le
carriole1089863carriole
cascable141510623cascable
cashable15159793cashable
castable121613973castable
causable1239973causable
chartable1636833chartable
curable112414513_curable
curbable1447663curbable
damnable1347593damnable
datable101714233da_table
dateable1149443dateable
drapable1377573drapable
drawable1467113drawable
dryable13237433_dryable
durable102312723_durable
eatable91717603ea_table
erasable10511043erasable
exorable1738933exorable
faceable15108493faceable
fadable13310463fa_dable
farfalle1445063farfalle
favorable1744583favorable
fireable131710223fireable
fordable1439593fordable
formable1539503formable
framable1537573framable
friable122612563_friable
fryable15277463_fryable
furlable1335893furlable
gainable1138933gainable
garble94118453ga_r_ble
gradable1238823gradable
grazable2036223grazable
hackable1937473hackable
hangable1438213hangable
hatable121713963ha_table
hateable1339373hateable
hearable131611603hearable
hirable121612313_hirable
hireable13139083hireable
horrible13135233horrible
inarable10313133inarable
inerrable11410153inerrable
jailable1737143jailable
jammable2144513jammable
lacerable1346943lacerable
lapsable12117383lapsable
laudable1137893laudable
learnable1145563learnable
mailable1239623mailable
makable15510203ma_kable
makeable1637253makeable
mappable1635923mappable
marble104219103ma_r_ble
maskable1638003maskable
namable11312343na_mable
nameable1238863nameable
narrate7313493narra_te
operable12410323operable
overable13513573overable
packable1838633packable
palpable1448033palpable
parables121613563pa_rables
parolable1347113parolable
parral85517533parra_l_
parrals94414573parra_ls
partible1238063partible
passable12310633passable
pawnable1535983pawnable
payable141711323pa_yable
portable12313203portable
pourable1239133pourable
radiable11611303radiable
raisable10311643raisable
ratable91717553ra_table
rateable10311443rateable
sailable10310563sailable
salable91415463sa_lable
saleable10312023saleable
salvable1338403salvable
sandable111612823sandable
satiable10310733satiable
saturable1146633saturable
savable121711863sa_vable
saveable1339003saveable
sayable121411613sa_yable
servable13310083servable
sharable131910693sharable
shareable1436733shareable
sorbable1239303sorbable
sortable10312483sortable
sparable121611983sparable
spareable1337263spareable
storable10310733storable
surfable1338443surfable
takable13310193ta_kable
takeable1437463takeable
talkable1437193talkable
tamable11312853ta_mable
tameable1238603tameable
tannable1039383tannable
tapeable1238823tapeable
tappable1436343tappable
tastable101511973tastable
taxable1639073ta_xable
tearable101512673tearable
terrible1046643terrible
titrable1038963titrable
tradable1139873tradable
triable92515393_triable
turnable1037853turnable
valuable1336863valuable
vaporable1645543vaporable
variables1444673variables
variably1637433variably
wadable13310233wa_dable
wadeable1437443wadeable
walkable1736063walkable
warble113516603wa_r_ble
washable16138043washable
wastable131410453wastable
waxable1937673wa_xable
wearable131510553wearable
wirable121610963_wirable
workable1737093workable

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.420425454.8
2DLD Change Limit1461622136.62622058.9
3Display Results2132130.0932290.3
 (SQL Overall)1786912137.13925030.3
 
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.