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

246 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
sailable1031056(None) 
bailable1238581bailable
jailable1737141jailable
mailable1239621mailable
salable91415461sa_lable
assailable1243432assailable
available1444902available
boilable1237792boilable
callable12310752callable
exilable1737202exilable
foilable1338062foilable
gainable1138932gainable
raisable10311642raisable
salably121610742sa_lably
saleable10312022saleable
salvable1338402salvable
sandable111612822sandable
satiable10310732satiable
savable121711862sa_vable
saveable1339002saveable
sayable121411612sa_yable
scalable121710232scalable
sealable101512692sealable
seisable10311372seisable
seizable1938722seizable
sellable101711822sellable
sizable1839892s_izable
skiable1338882ski_able
slidable1137952slidable
spallable1345832spallable
spillable1345352spillable
spoilable1345162spoilable
stainable1138092stainable
suitable10310892suitable
syllable13177772syllable
actable11313473_actable
addable11218843_addable
affable15117403_affable
agitable1138583agitable
alible8311973_a_lible
alliable1038433_alliable
amiable11312033_amiable
amicable1438433amicable
arable81821003_a_rable
availably1743253availably
bankable1677913bankable
bannable1278353bannable
barrable1249243barrable
billable12179503billable
bitable11312203_bitable
bribable1137223bribable
buildable1443523buildable
capable13313363ca_pable
cartable121314093cartable
cascable141510623cascable
cashable15159793cashable
castable121613973castable
causable1239973causable
citable11313463_citable
claimable1545703claimable
coinable12311583coinable
damnable1347593damnable
datable101714233da_table
dateable1149443dateable
disable10516433_disable
drainable1237583drainable
drillable1245133drillable
drivable1438023drivable
eatable91717603ea_table
editable11310423editable
estimable1346043estimable
evitable1339323evitable
faceable15108493faceable
fadable13310463fa_dable
faille93414743fail__le
fallible1355363fallible
farmable1538203farmable
fatigable1544863fatigable
fellable13179133fellable
fileable13179223_fileable
fillable13179573fillable
filmable15157133_filmable
finable122213623_finable
fixable19218193_fixable
friable122612563fri_able
furlable1335893furlable
gelable101710733_gelable
guidable1236203guidable
gullable1136463gullable
habitable1645953habitable
hackable1937473hackable
hangable1438213hangable
hatable121713963ha_table
hateable1339373hateable
healable131610173healable
hidable1399403_hidable
hirable121612313_hirable
imitable1239123imitable
isolable1038793isolable
jammable2144513jammable
joinable1737283joinable
killable14168133killable
labelable1344393labelable
laminable1337123laminable
lapsable12117383lapsable
laudable1137893laudable
liable81415813_li_able
likable13219413_likable
linable92214343_linable
livable122010323_livable
makable15510203ma_kable
makeable1637253makeable
malleable1376073malleable
mappable1635923mappable
maskable1638003maskable
millable121710133millable
minable112315073_minable
mixable18259173_mixable
namable11312343na_mable
nameable1238863nameable
navigable1544743navigable
oxidable1865123oxidable
packable1838633packable
paintable1337243paintable
palpable1448033palpable
parable111819773pa_rable
parolable1347113parolable
parsable12311693parsable
passable12310633passable
pawnable1535983pawnable
payable141711323pa_yable
peelable1238553peelable
pliable111610323pli_able
radiable11611303radiable
raiseable1147243raiseable
ratable91717553ra_table
rateable10311443rateable
reelable10311593reelable
reliable10313073reliable
resalable1138733resa_lable
ridable101412493_ridable
ruinable1039263ruinable
rulable9310533_rulable
sable74732163s___able
sailorly1143543sailorly
salal55425703sa_la_l_
salals65120083sa_la_ls
saleably1338213saleably
salvably1645443salvably
satiably1337823satiably
saturable1146633saturable
scalably15166703scalably
scannable1345643scannable
seeable91113943s_eeable
semblable1544843semblable
sendable111612043sendable
servable13310093servable
sewable121911173s_ewable
shakable17177683shakable
shakeable1844943shakeable
shamable15168803shamable
shameable1645573shameable
shapable15197803shapable
shapeable1645743shapeable
sharable131910693sharable
shareable1436733shareable
shavable16177273shavable
shedable1437423shedable
shiftable1744893shiftable
shippable1853793shippable
showable1636583showable
silage72715303s_ila_ge
silane62718053s_ila_ne
silicle937753s_ilicle
singable11159543singable
sinkable14178413sinkable
sizably2136613s_izably
sizeable1937113sizeable
skippable1952583skippable
slakable14177553slakable
slayable13157563slayable
sliceable1345443sliceable
smokable1636223smokable
sniffable1743773sniffable
sociable1239503sociable
soilage8169353soila_ge
soluble966103s_oluble
solvable1337473solvable
sorbable1239303sorbable
sortable10312483sortable
sowable121610753s_owable
sparable121611983sparable
spareable1337263spareable
spiracle1255803spiracle
stable83921643s__table
stackable1735993stackable
stageable1246343stageable
statable10310703statable
stateable1136903stateable
stealable1136573stealable
stewable1337133stewable
stickable1745543stickable
stonable1039843stonable
storable10310733storable
stowable1337613stowable
suable83920553s__uable
suitably1347593suitably
sulliable1145913sulliable
summable1436903summable
surfable1338443surfable
swayable16135533swayable
swimmable1842733swimmable
syllabled15163813syllabled
syllables14144753syllables
tabulable1344043tabulable
taille63116923tail__le
takable13310193ta_kable
takeable1437463takeable
talkable1437193talkable
tamable11312853ta_mable
tameable1238603tameable
tannable1039383tannable
tapeable1238823tapeable
tappable1436343tappable
tastable101511973tastable
taxable1639073ta_xable
tellable10169773tellable
tillable10159753tillable
tiltable10159013_tiltable
trainable1138943trainable
triable92515393tri_able
unsalable1148993unsa_lable
valuable1336863valuable
variable13310063variable
viable111613773_vi_able
violable1337543violable
voidable1466853voidable
wadable13310233wa_dable
wadeable1437443wadeable
walkable1736063walkable
washable16138043washable
wastable131410453wastable
waxable1937673wa_xable
willable13168683willable
wirable121610963_wirable
writable1338753writable

Search took 9 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.406440125.6
2DLD Change Limit1461622467.92318447.8
3Display Results2462460.1102236.4
 (SQL Overall)1786912468.43921174.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.