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

195 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
farmable153820(None) 
formable1539501formable
framable1537571framable
alarmable1345012alarmable
arable81821002_ar_able
barrable1249242barrable
cartable121314092cartable
faceable15108492faceable
fadable13310462fa_dable
farfalle1445062farfalle
filmable15157132filmable
fireable131710222fireable
flammable1844172flammable
foamable1537042foamable
fordable1439592fordable
formably1846662formably
frameable1645352frameable
friable122612562f_riable
fryable15277462f_ryable
furlable1335892furlable
jammable2144512jammable
namable11312342na_mable
parable111819772par_able
parsable12311692parsable
tamable11312852ta_mable
variable13310062variable
actable11313473_actable
addable11218843_addable
affable15117403_affable
affirmable2042623affirmable
amble95924643_a_m_ble
amiable11312033_amiable
arables91814973_ar_ables
arguable1135903_arguable
armhole1236943_armhole
awardable1543953awardable
bailable1238583bailable
bankable1677913bankable
bannable1278353bannable
barnacle1245943barnacle
bearable121512363bear_able
blamable1436693blamable
boardable1444893boardable
bramble133710033bram_ble
burnable1237263burnable
callable12310753callable
capable13313363ca_pable
carpale113414353carpa_le
cascable141510623cascable
cashable15159793cashable
castable121613973castable
causable1239973causable
chartable1636833chartable
claimable1545703claimable
curable112414513cur_able
curbable1447663curbable
damnable1347593damnable
datable101714233da_table
dateable1149443dateable
deformable1844193deformable
dimmable1536113dimmable
drapable1377573drapable
drawable1467113drawable
dryable13237433_dryable
durable102312723dur_able
eatable91717603ea_table
erasable10511043erasable
errable9312183_errable
fable105824753f___able
fallible1355363fallible
farfal123410183farfa_l_
farfals13268503farfa_ls
farle86929243far___le
farmwife1942173farmwife
fathomable2052103fathomable
fatigable1544863fatigable
favorable1744583favorable
feedable1437673feedable
fellable13179133fellable
female11310553f_ema_le
fermate122813003ferma_te
fileable13179223fileable
fillable13179573fillable
fimble133611753f_im_ble
finable122213623f_inable
findable14179023findable
fineable131810333fineable
fishable1637593fishable
fittable1337093fittable
fixable19218193f_ixable
flammables1942233flammables
flappable1843563flappable
flyable15307123f_lyable
foilable1338063foilable
foldable1437133foldable
forceable1646213forceable
forcible1545143forcible
forgeable1545403forgeable
formal113215203forma_l_
formally1638243formally
formals123312893forma_ls
formate123115093forma_te
formidable1843483formidable
frankable1844923frankable
fribble14287783f_ribble
fumble133214263f_um_ble
gainable1138933gainable
gamble115417183ga_m_ble
garble94118453gar__ble
gradable1238823gradable
grazable2036223grazable
hackable1937473hackable
hangable1438213hangable
hatable121713963ha_table
hateable1339373hateable
hearable131611603hear_able
hirable121612313hir_able
hireable13139083hireable
hummable1744583hummable
inarable10313133inar_able
jailable1737143jailable
lapsable12117383lapsable
laudable1137893laudable
learnable1145563learnable
mailable1239623mailable
makable15510203ma_kable
makeable1637253makeable
mappable1635923mappable
marble104219103mar__ble
maskable1638003maskable
nameable1238863nameable
packable1838633packable
palpable1448033palpable
parables121613563par_ables
parolable1347113parolable
partible1238063partible
passable12310633passable
pawnable1535983pawnable
payable141711323pa_yable
permeable1556823permeable
portable12313203portable
radiable11611303radiable
raisable10311643raisable
ramble104519973ra_m_ble
ratable91717553ra_table
rateable10311443rateable
reformable1745293reformable
sailable10310563sailable
salable91415463sa_lable
saleable10312023saleable
salvable1338403salvable
sandable111612823sandable
satiable10310733satiable
savable121711863sa_vable
saveable1339003saveable
sayable121411613sa_yable
scramble14177253scramble
servable13310093servable
shamable15168803shamable
sharable131910693shar_able
shareable1436733shareable
sorbable1239303sorbable
sortable10312483sortable
sparable121611983spar_able
spareable1337263spareable
summable1436903summable
surfable1338443surfable
takable13310193ta_kable
takeable1437463takeable
talkable1437193talkable
tamale83717403ta_ma_le
tameable1238603tameable
tannable1039383tannable
tapeable1238823tapeable
tappable1436343tappable
tastable101511973tastable
taxable1639073ta_xable
tearable101512673tear_able
tradable1139873tradable
triable92515393_triable
turnable1037853turnable
valuable1336863valuable
variables1444673variables
variably1637433variably
wadable13310233wa_dable
wadeable1437443wadeable
walkable1736063walkable
wamble134415753wa_m_ble
warble113516603war__ble
washable16138043washable
wastable131410453wastable
waxable1937673wa_xable
wearable131510553wear_able
wirable121610963wir_able
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.440406115.9
2DLD Change Limit1461621957.32619951.1
3Display Results1951950.0802437.5
 (SQL Overall)1786911957.84622774.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.