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

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

88 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
skateboards185342(None) 
skateboard1753571skateboard_
skateboarder1961522skateboarder
skateboarders2061172skateboarders
baseboards1545213_baseboards
pasteboards1653183pasteboards
sailboards1345483s_ailboards
scoreboards1653123scoreboards
seaboards1246443sea__boards
sideboards1444643s_ideboards
skateboarding2161653skateboarding
skateboardings2271213skateboardings
skimboards1943123sk_imboards
skyboards1943773sk__yboards
starboards1365303sta_rboards
wakeboards2044493_wakeboards
backboards2146194_backboards
bargeboards1752644bargeboards
baseboard1445544_baseboard_
beaverboards20142124beaverboards
blackboards2253834blackboards
callboards1544974_callboards
cardboards1645334_cardboards
centerboards1752604centerboards
chalkboards2352554chalkboards
clapboards17113674cla_pboards
dartboards1443884_dartboards
dashboards1743484_dashboards
fallboards1644434_fallboards
fibreboards1952664fibreboards
fireboards1645434_fireboards
flashboards2052474flashboards
footboards1644084foot_boards
freeboards1644474_freeboards
fretboards1643674fret_boards
garboards1346364_ga_rboards
hardboards1745164_hardboards
headboards1744334hea_dboards
kaleyards1773294_kale_yards
keyboards1943964_k_eyboards
kickboards1843354_kickboards
lapboards14105374_la_pboards
larboards1246984_la_rboards
leaderboards1652054leaderboards
leeboards1244794__leeboards
matchboards2152894_matchboards
outboards1246214_out_boards
packboards2144444_packboards
paperboards1863654_paperboards
pasteboard1553504pasteboard_
patchboards2153154_patchboards
plasterboards1881734plasterboards
preboards1446424__preboards
reboards1138774___reboards
safeguards1552044s_afeguards
sailboard1245904s_ailboard_
scabbards1643764sca__bbards
scoreboard1553414scoreboard_
scratchboards236824scratchboards
seaboard1147434sea__board_
shipboards1894104s_hipboards
sideboard1345174s_ideboard_
signboards1443344s_ignboards
skaters113512964skate___r_s
skimboard1843284sk_imboard_
skyboard1844004sk__yboard_
snakebirds1751654snakeb_irds
snowboards1643694s_nowboards
soundboards1552044soundboards
spacebands1752274spaceb_ands
splashboards2051144splashboards
starboard1275844sta_rboard_
statehoods1494154stateho_ods
stewards1236384s__te_wards
storyboards1752434storyboards
superboards1645714superboards
surfboards1643684s_urfboards
switchboards2351704switchboards
tackboards1944364_tackboards
tagboards1345134_ta_gboards
tailboards1345084_tailboards
teaboards1245394___teaboards
teeterboards1551904teeterboards
wakeboard1944754_wakeboard_
wallboards1644454_wallboards
washboards1944094_washboards
weatherboards2262604weatherboards
whitebeards2051674whitebeards

Search took 10 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 Filter1786911488190.420425454.8
2DLD Change Limit148819888.98616561.2
3Display Results88880.0461913.0
 (SQL Overall)178691889.45218905.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.