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

114 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
printable133820(None) 
paintable1337241paintable
pointable1337341pointable
drinkable1644112drinkable
grantable1257292grantable
plantable1337272plantable
priceable1546822priceable
prunable1237842prun_able
rentable101716332_rentable
rinsable10310042_rinsable
unprintable1555212unprintable
writable1338752wri_table
agitable1138583agi_table
bindable13169623_bindable
bitable11312203_bi_table
bribable1137223bri_bable
chantable1636893chantable
citable11313463_ci_table
coinable12311583coin_able
countable1348853countable
creatable1339563creatable
draftable1575563draftable
drainable1237583drain_able
drillable1245133drillable
drinkables1741943drinkables
drinkably1942713drinkably
drivable1438023dri_vable
driveable1544523driveable
editable11310423edi_table
erectable131210093erectable
evitable1339323evi_table
finable122213623_fin_able
findable14179023_findable
fineable131810333_fineable
fittable1337093_fittable
frankable1844923frankable
friable122612563fri__able
gainable1138933gain_able
giftable1465893_giftable
heritable1439453heri_table
hittable1336853_hittable
huntable1338093_huntable
ignitable1245463ignitable
imitable1239123imi_table
instable10313203__instable
irritable1148053irritable
joinable1737283join_able
knittable1544243knittable
liftable1376863_liftable
linable92214343_lin_able
lineable101811083_lineable
linkable14187263_linkable
listable10810313_listable
minable112315073_min_able
mineable121611053_mineable
mountable1346303mountable
paintball1342663paintball
palatable1346373palatable
patentable1444933patentable
pawnable1535983pawn_able
pentacle1239383p_entacle
perishable1745263perishable
permutable1644983permutable
pettable121710713p_ettable
pinnacle12416963p_innacle
pintail9311183p_intail_
pintailed1245553p_intailed
pintails10310163p_intails
pintle83818263p_int__le
pinwale1257843p_inwa_le
pitiable1238293p_itiable
pivotable1644563pivotable
pliable111610323pli__able
pointelle1144583pointelle
portable12313203p_ortable
potable112115363p__otable
predictable1844993predictable
pregnable1456693pregnable
presentable1546033presentable
preventable1844983preventable
previable1647533previable
principle1543753principle
pristane10310343prista_ne
probable1439053pr_obable
profitable1744963profitable
promotable1645033promotable
provable1539093pr_ovable
ratable91717553_r_atable
restable101618443_restable
retable91820403_r_etable
ridable101412493_ri_dable
rideable1158653_rideable
rinsible1046293_rinsible
rippable1435383_rippable
ruinable1039263ruin_able
rustable101511363_rustable
shiftable1744893shiftable
shrinkable1942493shrinkable
singable11159543_singable
sinkable14178413_sinkable
suitable10310893sui_table
thinkable1844063thinkable
tiltable10159013_tiltable
tractable1338513tractable
trainable1138943train_able
treatable1139323treatable
triable92515393tri__able
trustable1147123trustable
turntable1144983turntable
twistable1444273twistable
veritable1448743veri_table
windable14159153_windable
winnable13156983_winnable
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 Filter1786911486410.423422437.4
2DLD Change Limit1486411146.62622433.0
3Display Results1141140.0462478.3
 (SQL Overall)1786911147.09525185.5
 
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.