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

194 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
windable1415915(None) 
bindable13169621bindable
findable14179021findable
winnable13156981winnable
bendable131510852bendable
biddable14165672biddable
bondable13169272bondable
finable122213622fin_able
fineable131810332fineable
hidable1399402hi_dable
lendable11169462lendable
linable92214342lin_able
lineable101811082lineable
linkable14187262linkable
mendable131510582mendable
minable112315072min_able
mineable121611052mineable
ridable101412492ri_dable
rinsable10310032rinsable
sandable111612822sandable
sendable111612042sendable
singable11159532singable
sinkable14178412sinkable
vendable14159692vendable
wadable13310232w_adable
weldable1436862weldable
wieldable1543812wieldable
willable13168682willable
windage1237932winda_ge
windle104617952wind__le
wirable121610962wi_rable
addable11218843_addable
amendable1446043amendable
awardable1543953awardable
bankable1677913bankable
bannable1278353bannable
beddable14166923beddable
biddably17173543biddably
billable12179503billable
bindle94516263bind__le
binnacle12325633binnacle
bitable11312203bi_table
biteable1237933biteable
boundable1444843boundable
buildable1443523buildable
citable11313463ci_table
citeable1238413citeable
codable12311663_codable
coinable12311583coin_able
deniable11312083deniable
dimmable1536113dimmable
dindle84417223dind__le
dippable1536123dippable
disable10516433di_sable
dividable1645003dividable
drinkable1644113drinkable
dwindle12415883dwind__le
emendable1446233emendable
enable83318483_en_able
erodable1139203erodable
evadable1436363evadable
fadable13310463_fadable
feedable1437673feedable
fileable13179223fileable
fillable13179563fillable
filmable15157133filmable
finagle11238313fin_agle
finale94116763fin_a_le
fireable131710223fireable
fishable1637593fishable
fittable1337083fittable
fixable19218193fi_xable
foldable1437133foldable
fordable1439593fordable
gainable1138933gain_able
giftable1465893giftable
giveable14155753giveable
gradable1238823gradable
guidable1236203guidable
hangable1438203hangable
hirable121612313hi_rable
hireable13139083hireable
hittable1336843hittable
holdable1437073holdable
huntable1338093huntable
inarable10313123_inarable
indaba935613_indab_a
indabas1045843_indabas
indexable1947033_indexable
indole74516053_ind_ole
inedible1147463_inedible
inhale9411513_inha_le
instable10313193_instable
inviable1338523_inviable
joinable1737283join_able
kickable1535583kickable
killable14168133killable
kindle114414233kind__le
kissable1436853kissable
laudable1137893laudable
liable81415813li__able
lienable10188693lienable
liftable1376863liftable
likable13219413li_kable
likeable14166473likeable
lindane839023linda_ne
listable10810303listable
livable122010323li_vable
liveable13177663liveable
mandible1337543mandible
millable121710133millable
missable12311533missable
mixable18259173mi_xable
moldable1337103moldable
ownable1237283own_able
oxidable1865123oxidable
paintable1337243paintable
pinnacle12416963pinnacle
pinwale1257843pinwa_le
pitiable1238293pitiable
pointable1337343pointable
printable1338203printable
readable11313163readable
rendible11128353rendible
rentable101716333rentable
rideable1158653rideable
rinsible1046293rinsible
rippable1435383rippable
ruinable1039263ruin_able
shedable1437423shedable
sizable1839893si_zable
sizeable1937113sizeable
slidable1137953slidable
soundable1245983soundable
spendable1446463spendable
swimmable1842733swimmable
swindle11389183swind__le
tannable1039383tannable
tenable93214493ten_able
thinkable1844043thinkable
tillable10159753tillable
tiltable10159013tiltable
tippable1435263tippable
tithable1336853tithable
titrable1038963titrable
tradable1139873tradable
tunable92511313tun_able
tuneable1038913tuneable
twistable1444273twistable
unable83819223_un_able
undoable1139053_undoable
unfindable1644863unfindable
unwinnable1544093unwinnable
vendables15165153vendables
vendible14156473vendible
viable111613773vi__able
viewable1635223viewable
vincible1544753vincible
vindicable1843903vindicable
violable1337543violable
vitiable1337503vitiable
voidable1466853voidable
wadeable1437443wadeable
walkable1736063walkable
wandle105316663wand__le
wannabe1234533wannab_e
wannabee1343993wannabee
washable16138043washable
wastable131410453wastable
waxable1937673w_axable
wearable131510553wearable
weighable1843143weighable
wettable13148043wettable
widdle113814843wi_d_dle
wimble133211913wi__mble
windages1338263windages
windbag1444123wind_bag
windbags1544523windbags
windbell1443083windbell
windfall1544203windfall
windfalls1643723windfalls
windgall1343853windgall
windgalls1443133windgalls
windily1437943wind_ily
windled123713483wind__led
windles113518493wind__les
windmill14133513windmill
windpipe1643183windpipe
winkle133812833win__kle
wintle94014603win__tle
workable1737093workable
writable1338753writable
writeable1444613writeable
yieldable1543353yieldable

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 Filter1786911461620.1701051123.5
2DLD Change Limit1461621946.62622058.9
3Display Results1941940.0802425.0
 (SQL Overall)1786911946.87625987.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.