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

44 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
punchboards216209(None) 
punchboard2062241punchboard_
patchboards2153152patchboards
buckboards2143613bu_ckboards
duckboards2042723du_ckboards
matchboards2152893matchboards
packboards2144443p_ackboards
patchboard2053513patchboard_
punchballs1952603punchb_alls
backboards2146194_backboards
blackboards2253834blackboards
buckboard2044234bu_ckboard_
cupboards1643814cu__pboards
dashboards1743484_dashboards
duckboard1943014du_ckboard_
flashboards2052474flashboards
hunchbacks2652254hunchb_acks
inboards1145844_in__boards
kickboards1843354_kickboards
linerboards1452504linerboards
lunchboxes2451564lunchbo_xes
matchboard2053274matchboard_
outboards1246214ou__tboards
packboard2044844p_ackboard_
paperboards1863654paperboards
pasteboards1653184pasteboards
pegboards1544024p__egboards
pilchards1743924pilch__ards
pochards1646854p_och__ards
preboards1446424p__reboards
pressboards1652244pressboards
punchball1852884punchb_a_ll
puncheons1643914puncheo__ns
punchers152610074punch__er_s
rubboards1443284ru__bboards
snowboards1643694_snowboards
soundboards1552044soun_dboards
splashboards2051144splashboards
superboards1645714superboards
surfboards1643684su_rfboards
switchboards2351704switchboards
tackboards1944364_tackboards
uphoards1443764_u_ph_oards
washboards1944094_washboards

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.406440125.6
2DLD Change Limit148819449.31315979.7
3Display Results44440.0301466.7
 (SQL Overall)178691449.74918329.2
 
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.