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

392 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
friable12261256(None) 
fribble14287781fribble
fryable15277461fryable
triable92515391triable
amiable11312032amiable
arable81821002ar_able
bribable1137222bribable
dribble12368602dribble
drivable1438022drivable
dryable13237432dryable
errable9312182errable
fable105824752f__able
fadable13310462fadable
farmable1538202farmable
fimble133611752f_imble
finable122213622finable
fireable131710222fireable
fixable19218192fixable
flyable15307122flyable
foible11410382foi_ble
foilable1338062foilable
fordable1439592fordable
formable1539502formable
framable1537572framable
friarly13316212friarly
fribbled16305742fribbled
fribbler15265952fribbler
fribbles15287712fribbles
frijole1734582frijole
frisbee12298512frisbee
frizzle18367042frizzle
furlable1335892furlable
gribble12297272gribble
hirable121612312hirable
liable81415812_liable
pliable111610322pliable
ridable101412492_ridable
skiable1338882skiable
variable13310062variable
viable111613772_viable
wirable121610962wirable
writable1338752writable
able66340533___able
actable11313473actable
addable11218843addable
affable15117403affable
affixable2443343affixable
agitable1138583agitable
alible8311973ali_ble
alliable1038433alliable
amiably1438303amiably
amicable1438433amicable
arables91814973ar_ables
arguable1135903arguable
bailable1238583bailable
barrable1249243barrable
bible95119423_bi_ble
bitable11312203bitable
boilable1237793boilable
brabble10349973brabble
braille939713braille
bramble133710033bramble
bribe94820783bri_b_e
bribee104316363bri_bee
brickle15279933brickle
bricole112810493bricole
bridle94115463bri_dle
brindle104210103brindle
bristle91910103bristle
brittle9168603brittle
burnable1237263burnable
buyable1437493buyable
cable95329913__cable
capable13313363capable
cartable121314093cartable
citable11313463citable
codable12311663codable
coinable12311583coinable
cradle93313163cr_adle
cribbled15305803cribbled
crimple13408693crimple
cringle103010353cringle
crinkle13359413crinkle
cripple13378583cripple
crumble133410403crumble
curable112414513curable
curbable1447663curbable
datable101714233datable
deniable11312083deniable
derivable1548063derivable
dibble114013843_dibble
disable10516433disable
doable93115243_doable
dowable13189453dowable
drabble12238883drabble
drably123511613dr_ably
drainable1237583drainable
drapable1377573drapable
drawable1467113drawable
dribbled14376593dribbled
dribbler13316313dribbler
dribbles13348393dribbles
dribblet13347543dribblet
dribbly15274953dribbly
driblet103712243dri_blet
drillable1245133drillable
drinkable1644113drinkable
driveable1544523driveable
drizzle16285913drizzle
drumble12337893drumble
dupable12238383dupable
durable102312723durable
dutiable1137373dutiable
dyable12308983_dyable
dyeable1337303dyeable
eatable91717603eatable
edible969353edi_ble
editable11310423editable
effable15106673effable
enable83318483_enable
enviable1337853enviable
equable1849253equable
erasable10511043erasable
erodable1139203erodable
evitable1339323evitable
exilable1737203exilable
expiable1946113expiable
eyeable1239063eyeable
fabled124216383f__abled
fabler116115813f__abler
fables114921673f__ables
faceable15108493faceable
faille93414743fai_lle
farfalle1445063farfalle
farle86929243f__arle
fatigable1544863fatigable
feeble1138253f_eeble
feedable1437673feedable
fellable13179133fellable
female11310553fema_le
fenagle11197153fenagle
feriae95618603feria__e
ferial94621253feria_l_
fiacre1137623f_iacre
fiance11310743f_iance
fibre104812843f_i_bre
fickle153912973f_ickle
fiddle113613383f_iddle
file75446643f_i__le
fileable13179223fileable
fillable13179573fillable
fille84327403f_i_lle
filmable15157133filmable
fimbles143510663f_imbles
finagle11238313finagle
finale94116763f_inale
findable14179023findable
fineable131810333fineable
fipple13329063f_ipple
fishable1637593fishable
fittable1337093fittable
fizzle17369713f_izzle
flickable2043983flickable
foamable1537043foamable
foibles1238853foi_bles
foldable1437133foldable
forceable1646213forceable
forcible1545143forcible
forgeable1545403forgeable
forgivable1942743forgivable
formably1846663formably
formidable1843483formidable
frae75330473fr_a__e
fragile1147843fragile
frail85220213fr_ail_
frailer10319943fr_ailer
frailly1337313frailly
frails93716473fr_ails
fraise94214913fr_aise
frame105821803fr_a_me
frameable1645353frameable
frankable1844923frankable
frappe13286953fr_appe
frazzle18305223frazzle
freckle16106643freckle
freebee1238043freebee
freebie1236043freebie
freezable2345093freezable
friar85414273fria__r
friaries11310083friaries
friars93812093fria_rs
friary124010093fria_ry
fribblers16314193fribblers
fridge11379253fri_dge
frieze18378143fri_eze
frigate11311063frigate
frijol1634123frijol_
frijoles1834373frijoles
frill84917563fri__ll
frilled113911603fri_lled
friller104111743fri_ller
frills94414223fri_lls
frilly124111443fri_lly
fringe104013953fri_nge
frisbees13295013frisbees
frise85322453fri__se
frisee94217993fri_see
frivol1235113frivol_
frivoled1534043frivoled
frivoler1443933frivoler
frivols1334743frivols
frizzled20325703frizzled
frizzler19345843frizzler
frizzles19297283frizzles
frizzly21455793frizzly
fumble133214263f_umble
fusible1237023fusible
gable85325523__gable
gainable1138933gainable
gelable101710733gelable
getable101712553getable
grabble12339643grabble
gradable1238823gradable
grazable2036223grazable
gribbles13307363gribbles
griddle1035503griddle
grille74315743gri_lle
gripple12416613gripple
gristle8169223gristle
grizzle16306113grizzle
growable1435623growable
grumble12349233grumble
guidable1236203guidable
hatable121713963hatable
heritable1439453heritable
hewable15177823hewable
hidable1399403hidable
hireable13139083hireable
imitable1239123imitable
inviable1338523inviable
irrigable1246233irrigable
irritable1148053irritable
jailable1737143jailable
joinable1737283joinable
kibble143910953_kibble
leviable1337513leviable
likable13219413likable
linable92214343linable
livable122010323livable
losable91910953losable
lovable12179553lovable
mailable1239623mailable
makable15510203makable
minable112315073minable
miracle1138843miracle
mixable18259173mixable
movable14189433movable
mutable11312303mutable
namable11312343namable
nibble103713283_nibble
nimble103412943_nimble
notable92114903notable
obviable1543863obviable
oracle84313293or_acle
oriole6814293ori_ole
ownable1237283ownable
oxidable1865123oxidable
parable111819773parable
parsable12311693parsable
payable141711323payable
pitiable1238293pitiable
pliably14147383pliably
pokable15209503pokable
portable12313203portable
posable112212783posable
potable112115363potable
preamble1436383preamble
previable1647533previable
priceable1546823priceable
prickle153611013prickle
printable1338203printable
probable1439053probable
provable1539093provable
prunable1237843prunable
quibble2034713quibble
rabble103818243_rabble
radiable11611303radiable
raisable10311643raisable
rale45050563_r_a_le
ramble104519973_ramble
ratable91717553ratable
reliable10313073reliable
retable91820403retable
rial45938093_ria_l_
rials55026673_ria_ls
ribald9209293_ribald
riblet84222443_ri_blet
riddle83915713_riddle
rideable1158653_rideable
riffle124210233_riffle
rifle85518333_ri_fle
rile45650533_ri__le
rille55728733_ri_lle
rimple103814583_rimple
rinsable10310043_rinsable
rippable1435383_rippable
ripple103413913_ripple
risible937923_risible
roble75223023_r_oble
ropable111611333ropable
rouble83913313_rouble
rowable121510303rowable
rubble104315673_rubble
ruble74521253_r_uble
ruinable1039263ruinable
rulable9310533rulable
rumble103718813_rumble
sable74732163__sable
sailable10310563sailable
salable91415463salable
satiable10310733satiable
savable121711863savable
sayable121411613sayable
scribble14175433scribble
seeable91113943seeable
seisable10311373seisable
seizable1938723seizable
servable13310083servable
sewable121911173sewable
sizable1839893sizable
slidable1137953slidable
sociable1239503sociable
sorbable1239303sorbable
sortable10312483sortable
sowable121610753sowable
stable83921643_stable
suable83920553_suable
suitable10310893suitable
surfable1338443surfable
table75429603__table
takable13310193takable
tamable11312853tamable
taxable1639073taxable
tenable93214493tenable
thimble1435873thimble
totable92313363totable
towable121910113towable
tradable1139873tradable
trainable1138943trainable
treacle939973treacle
treadle8310103treadle
treble8311663tr_eble
tremble1138003tremble
triage72812893tria_ge
trial54926353tria_l_
trials64319883tria_ls
triangle935533triangle
triazole1744153triazole
tribade1037293tribade
tribal8611133tribal_
tribals9610753tribals
tribe74420273tri_b_e
trickle133613443trickle
trifle94012883tri_fle
trindle83311363trindle
triple84215923tri_ple
trouble957713trouble
tunable92511313tunable
turnable1037853turnable
typable1435883typable
unable83819223_unable
unridable1248293unridable
unviable1338703unviable
urial54823023uria_l_
urials64415193uria_ls
usable84012553_usable
useable9911063useable
variables1444673variables
variably1637433variably
veritable1448743veritable
viably14199833_viably
vitiable1337503vitiable
vocable14189673vocable
voidable1466853voidable
votable122111373votable
wadable13310233wadable
waxable1937673waxable
wimble133211923_wimble
workable1737093workable
wriggle12316213wriggle
wrinkle14296923wrinkle
writeable1444613writeable

Search took 7 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.406440125.6
2DLD Change Limit1340273925.86022871.5
3Display Results3923920.1402800.0
 (SQL Overall)1786913926.40627894.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.