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

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

72 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
breadboarding206158(None) 
breadboard1652883breadboard___
breadboarded1981203breadboard_ed
breadboards1752503breadboard__s
preboarding1744273pre__boarding
reboarding1445673_re__boarding
billboarding1851814b_illboarding
bodyboarding2261684b_odyboarding
clapboarding2051554_clapboarding
keyboarding2261824_ke_yboarding
readorning1245724_read_o_rning
rekeyboarding2461094_rekeyboarding
starboarding1652074_starboarding
bearbaiting1643165b_earb_aiting
bearding124011945b_e____arding
becowarding2052535b_e_cowarding
bedboard14115725b_e_dboard___
bedboards15114875b_e_dboard__s
bedwarfing2042465b_e_d_warfing
belaboring1544035b_elabo_r_ing
belabouring1652335b_elabour_ing
boarding123110235_____boarding
bombarding1843835b__omb_arding
bradding13268935br_ad____ding
bradycardia206875br_adycardi_a
bradycardias216745br_adycardias
breading123515465bre____a_ding
breadwinning19121195bread_winning
breakfasting2251565brea_kfasting
breastfeeding206775breastfeeding
breathtaking2271615breathta_king
broadcasting1852035broad_casting
broadsiding1652095broad__siding
deadheading1852065_deadhea_ding
debearding1543735_de__bearding
freeloading1642855fre_eloa_ding
headboard1644935_headboard___
headboards1744335_headboard__s
preabsorbing1951975prea_bsorbing
preadapting1743655pread__apting
preadopting1743995pread_o_pting
preloading1446585pre__loa_ding
prerecording1852115prereco_rding
reabsorbing1642765_rea_bsorbing
readapting1445155_read__apting
readding11411365_read____ding
readopting1465515_read_o_pting
reappearing1643945_reappear_ing
reassorting1245025_reasso_rting
reboring11312785_re__bo_r_ing
rebounding1435305_re__bounding
recording131311625_re__co_rding
redbaiting1446265_re_db_aiting
redemanding1643485_re_demanding
redounding1345215_re_d_ounding
reembarking2042675_reemb_arking
regarding12149155_re___garding
reloading1189885_re__loa_ding
rerecording1543305_rereco_rding
retarding111110655_re___tarding
rewarding14148835_re___warding
rewording14158545_re__wo_rding
roadholding1751615_roadho_lding
sailboarding1652125_sailboarding
scabbarding1951835_sca_bbarding
skateboarding2161655skateboarding
snowboarding1981925_snowboarding
speedboating1851385speedboa_ting
storyboarding20101395storyboarding
surfboarding1951575_surfboarding
trademarking2052025tr_ademarking
wakeboarding23352905_wakeboarding

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 Filter1786911247900.390458182.1
2DLD Change Limit124790728.62614466.7
3Display Results72720.0461565.2
 (SQL Overall)178691729.06219718.7
 
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.