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

87 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
preboards144642(None) 
preboard1338261preboard_
reboards1138771_reboards
fireboards1645432fireboards
freeboards1644472freeboards
fretboards1643672fretboards
leeboards1244792leeboards
pegboards1544022pegboards
preboarded1663892preboarded
preloads1157512preloa_ds
pressboards1652242pressboards
reboard10310762_reboard_
bargeboards1752643bargeboards
baseboards1545213baseboards
bedboards15114873bedboards
boards94616933___boards
boxboards2144263boxboards
breadboards1752503breadboards
cardboards1645333cardboards
corkboards1944113corkboards
cupboards1643813cupboards
dartboards1443883dartboards
debeards1235503_debeards
fibreboards1952663fibreboards
fireboard1546613fireboard_
freeboard1545253freeboard_
fretboard1543983fretboard_
garboards1346363garboards
hardboards1745163hardboards
inboards1145843_inboards
keyboards1943963keyboards
lapboards14105373lapboards
larboards1246983larboards
leeboard1145433leeboard_
mopboards1643753mopboards
outboards1246213outboards
packboards2144443packboards
paperboards1863653paperboards
pasteboards1653183pasteboards
pegboard1444803pegboard_
petards104311153p_e_tards
piebalds1344343pieb_alds
prearms11369173pre__arms
prebade12310283preb_a_de
prebakes1639013preb_akes
prebends13347883preb_ends
prebids12399883preb__ids
prebinds13357733preb_inds
preboarding1744273preboarding
preboils1267293prebo_ils
prebooks1656303prebo_oks
prebound1345893prebound_
prebuilds1442633prebuilds
preforms1537403prefo_rms
preload1049813preloa_d_
premolars1345023premolar_s
premolds1345843premo_lds
prepares122014163pre_pares
presoaks1436603presoa_ks
presorts105311683preso_rts
pressboard1553033pressboard_
pretors9316813preto_r_s
prewarms15406733pre_warms
prewarns13456943pre_warns
preworks17599013prewo_rks
probands13228393prob_ands
rebars84019833_reb_ar_s
reboarded1365613_reboarded
rebores95319163_rebo_res
rebounds1156023_rebounds
records105213923_reco_rds
regards94112563_re_gards
reloads8911313_reloa_ds
retards85015003_re_tards
rewards114813993_re_wards
rewords115413983_rewo_rds
reynards1244303_reynards
rubboards1443283rubboards
scoreboards1653123scoreboards
seaboards1246443seaboards
sideboards1444643sideboards
skyboards1943773skyboards
superboards1645713superboards
surfboards1643683surfboards
tagboards1345133tagboards
teaboards1245393teaboards
wakeboards2044493wakeboards

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 Limit148641877.18620684.8
3Display Results87870.0302900.0
 (SQL Overall)178691877.63923391.9
 
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.