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

70 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
spottable134534(None) 
pettable121710712_pettable
portable12313202_portable
potable112115362_po_table
sortable10312482s_ortable
spoilable1345162spoilable
adoptable1444753adoptable
boatable121610263_boatable
bootable12179223_bootable
cuttable1247953_cuttable
deportable1545653deportable
exportable2144603exportable
fittable1337093_fittable
floatable1444983floatable
gettable11178133_gettable
hittable1336853_hittable
importable1646553importable
knittable1544243knittable
nettable101610243_nettable
notable92114903_no_table
pitiable1238293_pitiable
pointable1337343_pointable
pokable15209503_po_kable
portables1337873_portables
portably1539313_portably
posable112212783_po_sable
potables12179703_po_tables
pottage103310603_potta_ge
pottle84416103_pott__le
pourable1239133_pourable
quotable1936493quo_table
reportable1446953reportable
rotatable1146653_rotatable
satiable10310733s_atiable
scoopable1544863scoopable
scrutable1346043scrutable
shiftable1744893shiftable
shockable2044703shockable
showable1636583sho_wable
smokable1636223smo_kable
smokeable1743853smokeable
sociable1239503s_ociable
solvable1337473s_olvable
sorbable1239303s_orbable
sortably1338803s_ortably
sowable121610753s_o_wable
spallable1345833spallable
sparable121611983sp_arable
spareable1337263spareable
speakable1745373speakable
spectacle1544083spectacle
spendable1446463spendable
spillable1345353spillable
spittle937923spitt__le
spottily1335153spott_ily
stable83921643s___table
statable10310703s_tatable
stateable1136903stateable
statutable1242643statutable
stonable1039843sto_nable
stoppable1544103stoppable
storable10310733sto_rable
stowable1337613sto_wable
suitable10310893s_uitable
supportable1752693supportable
totable92313363_to_table
toteable1048353_toteable
votable122111373_vo_table
voteable1347213_voteable
wettable13148043_wettable

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.1531167915.0
2DLD Change Limit148641707.11020905.9
3Display Results70700.0332121.2
 (SQL Overall)178691707.29624491.6
 
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.