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

55 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
baseboard144554(None) 
baseboards1545211baseboards
backboard2047182backboard
bargeboard1652992bargeboard
baseborn1244452basebo_rn
dashboard1643802dashboard
pasteboard1553502pasteboard
wakeboard1944752wakeboard
washboard1844522washboard
aboard9312613_a__board
aboveboard1851683aboveboard
backboards2146193backboards
bareboat1249943bareboa_t
bareboats1345833bareboats
bareboned1445103bareboned
bargeboards1752643bargeboards
baseball1245623baseb_all
bastard103012423bas__tard
beaverboard19142263beaverboard
bedboard14115723b_edboard
billboard1444713billboard
blackboard2144253blackboard
bluebeard1442683bluebeard
bodyboard1843303bodyboard
boxboard2044613b_oxboard
buckboard2044233buckboard
callboard1445663callboard
cardboard1545863cardboard
caseload1145623caseloa_d
dartboard1344253dartboard
dashboards1743483dashboards
fallboard1545053fallboard
fireboard1546613fireboard
flashboard1952723flashboard
freeboard1545253freeboard
garboard1247243ga_rboard
hardboard1645583hardboard
lapboard1355783la_pboard
larboard1157663la_rboard
leeboard1145433_leeboard
packboard2044843packboard
paperboard1764113paperboard
pasteboards1653183pasteboards
preboard1338263_preboard
reboard10310763__reboard
sailboard1245903sailboard
seaboard1147433__seaboard
sideboard1345173sideboard
skateboard1753573skateboard
tackboard1844723tackboard
tagboard1245563ta_gboard
tailboard1245773tailboard
wakeboards2044493wakeboards
wallboard1545023wallboard
washboards1944093washboards

Search took 7 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 Limit148641556.25023782.6
3Display Results55550.0301833.3
 (SQL Overall)178691556.70326658.4
 
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.