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 “flyable” 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
flyable1530712(None) 
fryable15277461fryable
buyable1437492buyable
dryable13237432dryable
dyable12308982_dyable
fable105824752f__able
fadable13310462fadable
fellable13179132fellable
fileable13179222fileable
fillable13179572fillable
filmable15157132filmable
finable122213622finable
fixable19218192fixable
flyblew1841402fly_blew
foldable1437132foldable
friable122612562friable
liable81415812_liable
payable141711322payable
playable15137922playable
pliable111610322pliable
sayable121411612sayable
slayable13157562slayable
unflyable1744632unflyable
able66340533___able
actable11313473actable
addable11218843addable
affable15117403affable
alible8311973al_ible
alliable1038433alliable
amiable11312033amiable
arable81821003_arable
billable12179503billable
bitable11312203bitable
blamable1436693blamable
cable95329913__cable
callable12310753callable
capable13313363capable
citable11313463citable
closable12168003closable
clubable1436093clubable
codable12311663codable
copyable1736623copyable
culpable1436283culpable
curable112414513curable
datable101714233datable
delayable1546063delayable
disable10516433disable
doable93115243_doable
dowable13189453dowable
dupable12238383dupable
durable102312723durable
dyeable1337303dyeable
eatable91717603eatable
effable15106673effable
enable83318483_enable
equable1849253equable
errable9312183errable
eyeable1239063eyeable
fabled124216383f__abled
fabler116115813f__abler
fables114921673f__ables
faceable15108493faceable
fallible1355363fallible
farle86929243f__arle
farmable1538203farmable
feeble1138253f_eeble
feedable1437673feedable
female11310553fema_le
fenagle11197153fenagle
filtrable1484263filtrable
fimble133611753f_imble
finagle11238313finagle
finale94116763fina_le
findable14179023findable
fineable131810333fineable
fireable131710223fireable
fishable1637593fishable
fittable1337093fittable
flab96628353fl_ab__
flabby1634573fl_abby
flabs105818643fl_ab_s
flail85316183fl_ail_
flailed1137303fl_ailed
flails94313003fl_ails
flake125119973fl_a_ke
flambe13489153fl_ambe
flambee144210013flambee
flame105124443fl_a_me
flammable1844173flammable
flange103411973fl_ange
flappable1843563flappable
flare84823633fl_a_re
flatlet10312253fl_atlet
flatly123110213fl_atly
fleabag1342923fleabag
fleabane1343633fleabane
fleabite1354163fleabite
flexible2043143flexible
flexile1735073flexile
flickable2043983flickable
floatable1444983floatable
floatel10308013floatel
floggable1642243floggable
floodable1544013floodable
flushable1743573flushable
flyaway1943163flyaway
flybelt1594453flybelt
flyblow1841903fly_blow
flyboy17113913fly_boy
flyby1676003fly_b_y
flybys1792773fly_bys
flyte115713943fly__te
foamable1537043foamable
foible11410383f_oible
foilable1338063foilable
fordable1439593fordable
formable1539503formable
framable1537573framable
fribble14287783fribble
fumble133214263f_umble
furlable1335893furlable
fusible1237023fusible
gable85325523__gable
gelable101710733gelable
getable101712553getable
gullable1136463gullable
hatable121713963hatable
helpable1536603helpable
hewable15177823hewable
hidable1399403hidable
hirable121612313hirable
holdable1437073holdable
killable14168133killable
kleagle1242933kleagle
label75019383_l_abel
labile8315223_l_abile
ladle66320443_l_adle
likable13219413likable
linable92214343linable
livable122010323livable
losable91910953losable
lovable12179553lovable
lyase85512413_lya_se
makable15510203makable
meltable12310473meltable
millable121710133millable
minable112315073minable
mixable18259173mixable
moldable1337103moldable
movable14189433movable
mutable11312303mutable
namable11312343namable
notable92114903notable
obeyable1544113obeyable
ownable1237283ownable
palpable1448033palpable
parable111819773parable
payables15166483payables
payably17177093payably
placable14169243placable
pliably14147383pliably
plowable1535913plowable
pokable15209503pokable
posable112212783posable
potable112115363potable
ratable91717553ratable
reliable10313073reliable
retable91820403retable
ridable101412493ridable
ropable111611333ropable
rowable121510303rowable
rulable9310533rulable
sable74732163__sable
salable91415463salable
saleable10312023saleable
salvable1338403salvable
savable121711863savable
seeable91113943seeable
sellable101711823sellable
sewable121911173sewable
sizable1839893sizable
skiable1338883skiable
slakable14177553slakable
slidable1137953slidable
solvable1337473solvable
sowable121610753sowable
stable83921643_stable
suable83920553_suable
swayable16135533swayable
syllable13177773syllable
table75429603__table
takable13310193takable
talkable1437193talkable
tamable11312853tamable
taxable1639073taxable
tellable10169773tellable
tenable93214493tenable
tillable10159753tillable
tiltable10159013tiltable
totable92313363totable
towable121910113towable
triable92515393triable
tunable92511313tunable
typable1435883typable
unable83819223_unable
usable84012553_usable
useable9911063useable
valuable1336863valuable
viable111613773_viable
vocable14189673vocable
votable122111373votable
wadable13310233wadable
walkable1736063walkable
waxable1937673waxable
weldable1436863weldable
willable13168683willable
wirable121610963wirable

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.390458182.1
2DLD Change Limit1340272176.81319672.2
3Display Results2172170.0762855.3
 (SQL Overall)1786912177.27924548.8
 
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.