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 “thinkable” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

74 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
thinkable184406(None) 
thinkably2142631thinkably
drinkable1644112drinkable
linkable14187262_linkable
shrinkable1942492shrinkable
sinkable14178412_sinkable
unthinkable2053092unthinkable
bankable1677913_bankable
bindable13169623_bindable
chantable1636893chantable
checkable2244743checkable
chippable2073353chippable
clickable1944303clickable
coinable12311583coin_able
drinkables1741943drinkables
drinkably1942713drinkably
finable122213623_fin_able
findable14179023_findable
fineable131810333_fineable
flickable2043983flickable
frankable1844923frankable
gainable1138933gain_able
hackable1937473_hackable
hangable1438213_hangable
hidable1399403_hi_dable
hirable121612313_hi_rable
hireable13139083_hireable
hittable1336853_hittable
huntable1338093_huntable
joinable1737283join_able
kickable1535583_kickable
likable13219413_li_kable
linable92214343_lin_able
lineable101811083_lineable
minable112315073_min_able
mineable121611053_mineable
paintable1337243paintable
pointable1337343pointable
printable1338213printable
rinsable10310043_rinsable
ruinable1039263ruin_able
shakable17177683sh_akable
shiftable1744893shiftable
shippable1853793shippable
shockable2044703shockable
shunnable1443203shunnable
singable11159543_singable
stainable1138093stain_able
stickable1745543stickable
takable13310193t__akable
talkable1437193t_alkable
tannable1039383t_annable
tenable93214493t_en_able
thimble1435873thi__mble
tillable10159753t_illable
tiltable10159013t_iltable
tinkle103714453t_ink__le
tippable1435263t_ippable
tithable1336853t_ithable
titrable1038973t_itrable
trackable1736743trackable
trainable1138943train_able
triable92515393tri__able
truckable1744513truckable
tunable92511313t_un_able
tuneable1038913t_uneable
turnable1037853turn_able
turntable1144983turntable
twinkle1464773twink__le
twistable1444273twistable
unsinkable1645093unsinkable
unthinkably2352203unthinkably
windable14159153_windable
winnable13156983_winnable

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 Limit148641747.35620206.8
3Display Results74740.0332242.4
 (SQL Overall)178691747.81222873.9
 
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.