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

61 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
rekeyboarding246109(None) 
keyboarding2261822__keyboarding
reboarding1445673r__e_boarding
rekeyboard2052043rekeyboard___
rekeyboarded2381003rekeyboard_ed
rekeyboards2151893rekeyboard__s
wakeboarding23352903wake_boarding
bodyboarding2261684_bodyboarding
breadboarding2061584bre_adboarding
keyboardist2161564__keyboardist
preboarding1744274_pre_boarding
reembarking2042674re_emb_arking
rerecording1543304rere_co_rding
storyboarding20101394storyboarding
wakeboardings24952444wake_boardings
billboarding1851815_billboarding
boarding123110235_____boarding
clapboarding2051555_clapboarding
debearding1543735__de_bearding
freeloading1642855fre_e_loa_ding
keyboard1844505__keyboard___
keyboarded2151745__keyboard_ed
keyboarder2051725__keyboard_er
keyboarders2151345__keyboarders
keyboardists226925__keyboardists
keyboards1943965__keyboard__s
prerecording1852115prere_co_rding
reboring11312785r__e_bo_r_ing
rebounding1435305r__e_bounding
recensoring1444675recenso_r_ing
recording131311625r__e_co_rding
redecorating16115055rede_corating
redemanding1643485rede__manding
reearning1039055re_e___arning
reembodying2061585re_embo_dying
reembracing1852705re_embra_cing
reenforcing1742775re_enfo_rcing
reenlarging1342475re_e_nlarging
reexporting2143425re_expo_rting
regarding12149155r__e__garding
regearing112211415rege___ar_ing
rehearing132211765rehe___ar_ing
rehearsing1444345rehe___arsing
rekeying1637565rekey_____ing
relearning1135285rele___arning
reloading1189885r__e_loa_ding
remembering1843685rememb_er_ing
renegading1344595rene__ga_ding
rereading111212715rere___a_ding
retarding111110655r__e__tarding
retearing102214255rete___ar_ing
reverberating1953205reverberating
rewarding14148835r__e__warding
rewearing132310705rewe___ar_ing
rewording14158545r__e_wo_rding
sailboarding1652125_sailboarding
skateboarding2161655skateboarding
snowboarding1981925_snowboarding
starboarding1652075_starboarding
surfboarding1951575_surfboarding
weatherboarding2571305weatherboarding

Search took 9 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.406440125.6
2DLD Change Limit124790617.61016398.2
3Display Results61610.0302033.3
 (SQL Overall)178691618.04622208.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.