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

160 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
fishable163759(None) 
cashable15159792cashable
disable10516432dis_able
fightable1844372fightable
fileable13179222fileable
fillable13179572fillable
filmable15157132filmable
finable122213622fi_nable
findable14179022findable
fineable131810332fineable
fireable131710222fireable
fishpole1644052fishpole
fittable1337092fittable
fixable19218192fi_xable
flushable1743572flushable
kissable1436852kissable
listable10810312listable
missable12311532missable
tithable1336852tithable
washable16138042washable
biddable14165673biddable
billable12179503billable
bindable13169623bindable
bitable11312203bi_table
biteable1237933biteable
cascable141510623cascable
castable121613973castable
citable11313463ci_table
citeable1238413citeable
crushable1645263crushable
dimmable1536113dimmable
dippable1536123dippable
disabled1248713dis_abled
disabler1147913dis_abler
disables11410903dis_ables
disenable1249663disenable
dishabille16142813dishabille
fable105824753f___able
faceable15108493faceable
fadable13310463f_adable
farmable1538203farmable
feedable1437673feedable
fellable13179133fellable
figurable1543733figurable
filtrable1484263filtrable
fimble133611753fi__mble
finagle11238313fi_nagle
finale94116763fi_na_le
fiscal1139333fisca_l_
fiscally1646073fiscally
fiscals1238003fisca_ls
fishbolt1644663fishbolt
fishbone1644663fishbone
fisheye1644773fish_eye
fishily1637643fish_ily
fishkill1842143fishkill
fishlike18225873fishlike
fishline14237583fishline
fishpoles1743633fishpoles
fishtail1443983fishtail_
fishtailed1741863fishtailed
fishtails1543663fishtails
fishwife2042293fishwife
fissate103010033fissa_te
fissile10269653fis_sile
flickable2043983flickable
flyable15307123f_lyable
foamable1537043foamable
foilable1338063foilable
foldable1437133foldable
fordable1439593fordable
formable1539503formable
framable1537573framable
friable122612563f_riable
fryable15277463f_ryable
furlable1335893furlable
fusible1237023fus_ible
giftable1465893giftable
giveable14155753giveable
gustable11138203gustable
hidable1399403hi_dable
hirable121612313hi_rable
hireable13139083hireable
hittable1336853hittable
inhale9411513_inha_le
instable10313203instable
isolable1038793_isolable
issuable1046873issuable
kickable1535583kickable
killable14168133killable
kissably1744073kissably
liable81415813li__able
lienable10188693lienable
liftable1376863liftable
likable13219413li_kable
likeable14166473likeable
linable92214343li_nable
lineable101811083lineable
linkable14187263linkable
livable122010323li_vable
liveable13177663liveable
losable91910953los_able
maskable1638003maskable
millable121710133millable
minable112315073mi_nable
mineable121611053mineable
miscible1447673miscible
miserable1349653miserable
mishandle1544223mishandle
mislabel1296173mislabel
mixable18259173mi_xable
nestable101613673nestable
passable12310633passable
perishable1745263perishable
pitiable1238293pitiable
posable112212783pos_able
punishable1743283punishable
raisable10311643rais_able
raiseable1147243raiseable
relishable1544523relishable
restable101618443restable
ridable101412493ri_dable
rideable1158653rideable
rinsable10310043rinsable
rippable1435383rippable
risible937923ris_ible
rustable101511363rustable
sable74732163__s_able
seisable10311373seis_able
shale85332833__sha_le
shamble14149263__shamble
singable11159543singable
sinkable14178413sinkable
sizable1839893si_zable
sizeable1937113sizeable
stable83921643__stable
suable83920553__suable
tastable101511973tastable
testable101412623testable
tillable10159753tillable
tiltable10159013tiltable
tippable1435263tippable
titrable1038963titrable
twistable1444273twistable
unstable10313763unstable
usable84012553_us_able
useable9911063_useable
viable111613773vi__able
viewable1635223viewable
violable1337543violable
visible1236923vis_ible
visitable1445873visitable
vitiable1337503vitiable
washables17144743washables
wastable131410453wastable
weighable1843143weighable
willable13168683willable
windable14159153windable
winnable13156983winnable
wirable121610963wi_rable

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.1561145455.1
2DLD Change Limit1461621607.53319402.9
3Display Results1601600.0762105.3
 (SQL Overall)1786911607.76523012.4
 
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.