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

155 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
giftable146589(None) 
giftables1572591giftables
liftable1376861liftable
agitable1138582agi_table
bitable11312202bi_table
citable11313462ci_table
fittable1337092fittable
getable101712552g_etable
gettable11178132gettable
giveable14155752giveable
gustable11138202gustable
hittable1336852hittable
listable10810312listable
shiftable1744892shiftable
tiltable10159012tiltable
abatable1238023abatable
actable11313473_actable
affable15117403_affable
beatable121612243beatable
biddable14165673biddable
billable12179503billable
bindable13169623bindable
biteable1237933biteable
boatable121610263boatable
bootable12179223bootable
buffable1844393buffable
cartable121314093cartable
castable121613973castable
citeable1238413citeable
cogitable1446943cogi_table
cuttable1247953cuttable
datable101714233_datable
dilatable1246853dilatable
dimmable1536113dimmable
dippable1536123dippable
disable10516433di_sable
draftable1575563draftable
eatable91717603_eatable
editable11310423editable
effable15106673_effable
evitable1339323evitable
fable105824753__f_able
fightable1844373fightable
fileable13179223fileable
fillable13179573fillable
filmable15157133filmable
filtrable1484263filtrable
finable122213623fi_nable
findable14179023findable
fineable131810333fineable
fireable131710223fireable
fishable1637593fishable
fixable19218193fi_xable
gable85325523g___able
gainable1138933gainable
gelable101710733g_elable
getatable1235953getatable
giftedly1642933giftedly
giftee103512083gift__ee
giftware1542463giftware
gnawable1435683gnawable
gradable1238823gradable
grantable1257293grantable
grazable2036223grazable
growable1435623growable
guidable1236203guidable
gullable1136463gullable
gustables12165223gustables
hatable121713963_hatable
heatable131612043heatable
hidable1399403hi_dable
hirable121612313hi_rable
hireable13139083hireable
huntable1338093huntable
ignitable1245463ignitable
imitable1239123imitable
instable10313203instable
kickable1535583kickable
killable14168133killable
kissable1436853kissable
knittable1544243knittable
liable81415813li__able
lienable10188693lienable
likable13219413li_kable
likeable14166473likeable
limitable1345643limitable
linable92214343li_nable
lineable101811083lineable
linkable14187263linkable
livable122010323li_vable
liveable13177663liveable
meltable12310473meltable
millable121710133millable
minable112315073mi_nable
mineable121611053mineable
missable12311533missable
mixable18259173mi_xable
mutable11312303_mutable
nestable101613673nestable
nettable101610243nettable
notable92114903_notable
outfable1378813outfable
paintable1337243paintable
pettable121710713pettable
pitiable1238293pitiable
pivotable1644563pivotable
pointable1337343pointable
portable12313203portable
potable112115363_potable
printable1338203printable
quotable1936493quotable
ratable91717553_ratable
refutable1477863refutable
rentable101716333rentable
restable101618443restable
retable91820403_retable
ridable101412493ri_dable
rideable1158653rideable
rinsable10310043rinsable
rippable1435383rippable
rustable101511363rustable
singable11159543singable
sinkable14178413sinkable
sizable1839893si_zable
sizeable1937113sizeable
sniffable1743773sniffable
sortable10312483sortable
stable83921643__stable
statable10310703statable
suitable10310893suitable
table75429603___table
tastable101511973tastable
testable101412623testable
tillable10159753tillable
timetable1346873timetable
tippable1435263tippable
tithable1336853tithable
titrable1038963titrable
totable92313363_totable
twistable1444273twistable
unifiable1447343unifiable
unstable10313763unstable
viable111613773vi__able
viewable1635223viewable
violable1337543violable
visitable1445873visitable
vitiable1337503vitiable
votable122111373_votable
wastable131410453wastable
wettable13148043wettable
willable13168683willable
windable14159153windable
winnable13156983winnable
wirable121610963wi_rable
writable1338753writable

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.420425454.8
2DLD Change Limit1461621557.12620511.1
3Display Results1551550.0632460.3
 (SQL Overall)1786911557.60923484.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.