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

176 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
pitiable123829(None) 
pitiably1545841pitiably
vitiable1337501vitiable
bitable11312202bit_able
biteable1237932biteable
citable11313462cit_able
citeable1238412citeable
dutiable1137372dutiable
fittable1337092fittable
hittable1336852hittable
litigable1244222litigable
mitigable1444752mitigable
pettable121710712pettable
pliable111610322p_liable
potable112115362pot_able
satiable10310732satiable
tithable1336852tithable
titrable1038962titrable
actable11313473act_able
agitable1138583agit_able
alliable1038433alliable
amiable11312033_amiable
appliable1545053appliable
biddable14165673biddable
billable12179503billable
bindable13169623bindable
cuttable1247953cuttable
datable101714233dat_able
dateable1149443dateable
deniable11312083deniable
dimmable1536113dimmable
dippable1536123dippable
disable10516433di_sable
dividable1645003dividable
eatable91717603eat_able
editable11310423edit_able
emptiable1544843emptiable
enviable1337853enviable
estimable1346043estimable
evitable1339323evit_able
expiable1946113expiable
fatigable1544863fatigable
fileable13179223fileable
fillable13179573fillable
filmable15157133filmable
filtrable1484263filtrable
finable122213623fi_nable
findable14179023findable
fineable131810333fineable
fireable131710223fireable
fishable1637593fishable
fixable19218193fi_xable
friable122612563_friable
getable101712553get_able
gettable11178133gettable
giftable1465893giftable
giveable14155753giveable
hatable121713963hat_able
hateable1339373hateable
hidable1399403hi_dable
hirable121612313hi_rable
hireable13139083hireable
imitable1239123_imitable
inviable1338523inviable
kickable1535583kickable
killable14168133killable
kissable1436853kissable
knittable1544243knittable
leviable1337513leviable
liable81415813__liable
lienable10188693lienable
liftable1376863liftable
likable13219413li_kable
likeable14166473likeable
limitable1345643limitable
linable92214343li_nable
lineable101811083lineable
linkable14187263linkable
listable10810313listable
livable122010323li_vable
liveable13177663liveable
millable121710133millable
minable112315073mi_nable
mineable121611053mineable
missable12311533missable
mixable18259173mi_xable
mixible18195093mixi_ble
mutable11312303mut_able
nettable101610243nettable
notable92114903not_able
obviable1543863obviable
outfable1378813outfable
pacifiable1943073pacifiable
packable1838633packable
paintable1337243paintable
palpable1448033palpable
parable111819773p_arable
parsable12311693parsable
partible1238063parti_ble
passable12310633passable
patchable1845633patchable
pawnable1535983pawnable
payable141711323p_ayable
peccable1648123peccable
peelable1238553peelable
petiole9311303peti_ole
petrale9312623petra_le
pinnacle12416963pinnacle
pinwale1257843pinwa_le
pitfall1245823pitfa_ll
pitfalls1345373pitfalls
pitiful1245863pitiful_
pittance1246113pittance
pivotable1644563pivotable
placable14169243placable
playable15137923playable
pliably14147383p_liably
plowable1535913plowable
pointable1337343pointable
pokable15209503p_okable
portable12313203portable
posable112212783p_osable
potables12179703pot_ables
pourable1239133pourable
previable1647533previable
priceable1546823priceable
printable1338203printable
probable1439053probable
provable1539093provable
prunable1237843prunable
radiable11611303radiable
ratable91717553rat_able
rateable10311443rateable
reliable10313073reliable
retable91820403ret_able
ridable101412493ri_dable
rideable1158653rideable
rinsable10310043rinsable
rippable1435383rippable
risible937923risi_ble
satiably1337823satiably
singable11159543singable
sinkable14178413sinkable
sizable1839893si_zable
sizeable1937113sizeable
skiable1338883_skiable
sociable1239503sociable
spillable1345353spillable
spottable1345343spottable
stable83921643_st_able
suitable10310893suit_able
table75429603__t_able
tillable10159753tillable
tiltable10159013tiltable
tippable1435263tippable
totable92313363tot_able
toteable1048353toteable
triable92515393_triable
unifiable1447343unifiable
unviable1338703unviable
variable13310063variable
viable111613773__viable
viewable1635223viewable
violable1337543violable
visible1236923visi_ble
visitable1445873visitable
vitiate103412953vitia_te
votable122111373vot_able
voteable1347213voteable
wettable13148043wettable
willable13168683willable
windable14159153windable
winnable13156983winnable
wirable121610963wi_rable
writable1338753writ_able
writeable1444613writeable

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.423422437.4
2DLD Change Limit1461621767.07620656.0
3Display Results1761760.0802200.0
 (SQL Overall)1786911767.57923577.1
 
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.