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

175 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
jailable173714(None) 
bailable1238581bailable
mailable1239621mailable
sailable10310561sailable
available1444902available
boilable1237792boilable
callable12310752callable
exilable1737202exilable
foilable1338062foilable
gainable1138932gainable
jammable2144512jammable
joinable1737282joinable
raisable10311642raisable
salable91415462sa_lable
actable11313473_actable
addable11218843_addable
affable15117403_affable
agitable1138583agitable
alible8311973_a_lible
alliable1038433_alliable
amiable11312033_amiable
amicable1438433amicable
arable81821003_a_rable
assailable1243433assailable
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
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
jailbait1744063jailbait
judicable2143643judicable
jumpable2143953jumpable
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
ridable101412493_ridable
ruinable1039263ruinable
rulable9310533_rulable
salably121610743sa_lably
saleable10312023saleable
salvable1338403salvable
sandable111612823sandable
satiable10310733satiable
savable121711863sa_vable
saveable1339003saveable
sayable121411613sa_yable
scalable121710233scalable
sealable101512693sealable
seisable10311373seisable
seizable1938723seizable
sellable101711823sellable
sizable1839893_sizable
skiable1338883ski_able
slidable1137953slidable
spallable1345833spallable
spillable1345353spillable
spoilable1345163spoilable
stainable1138093stainable
suitable10310893suitable
syllable13177773syllable
tabulable1344043tabulable
taille63116923tail__le
takable13310193ta_kable
takeable1437463takeable
talkable1437193talkable
tamable11312853ta_mable
tameable1238603tameable
tannable1039383tannable
tapeable1238823tapeable
tappable1436343tappable
tastable101511973tastable
taxable1639073ta_xable
tellable10169773tellable
tillable10159753tillable
tiltable10159013_tiltable
trainable1138943trainable
triable92515393tri_able
valuable1336863valuable
variable13310063variable
viable111613773_vi_able
violable1337543violable
voidable1466853voidable
wadable13310233wa_dable
wadeable1437443wadeable
walkable1736063walkable
washable16138043washable
wastable131410453wastable
waxable1937673wa_xable
willable13168683willable
wirable121610963_wirable
writable1338753writable

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.423422437.4
2DLD Change Limit1461621756.36022981.4
3Display Results1751750.0602916.7
 (SQL Overall)1786911756.84326113.0
 
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.