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

78 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
reynards124430(None) 
reynard1135121reynard_
keycards1843062keycards
reboards1138772reboards
regards94112562re_gards
retards85015002re_tards
rewards114813992re_wards
bayards13379683bay_ards
beards94116673be__ards
bedwards1596393bedwards
beeyards1444593beeyards
boyards13399323boy_ards
canards10311203_canards
debeards1235503debeards
denars74621433de_nar_s
echards1337963_echards
foreyards1645503forey_ards
gurnards1043633gurnards
haywards1845873haywards
innards837153_innards
jeopards1843683jeopards
keyboards1943963keyboards
keycard1743663keycard_
keypads1743343keypa_ds
keywords1944323keywords
lanyards1266393lanyards
leewards1244983leewards
leopards1144753leopards
leotards945303leotards
menads95514383me_na_ds
nards65928463___nards
petards104311153pe_tards
preboards1446423preboards
readds84111643re__adds
reads64835273re__a_ds
rearms85114653re__arms
rears54739653re__ar_s
rearwards1344803rearwards
rebars84019833re_bar_s
reboard10310763reboard_
recharts1337663recharts
reclads1049993recla_ds
records105213923re_cords
redbirds1283873redbirds
redears82814453redear_s
redwares1239053redwares
reearns749103re_earns
reenacts1036993reenacts
regard85215773re_gard_
regears83012463regear_s
reheard11309023reheard_
rehears103312773rehear_s
relands85214883re_lands
relearns836303relearns
reloads8911313reloa_ds
remands104914883re_mands
remarks13329983re_marks
remnants1036843remnants
renails74917263re_nails
renames92418053re_names
rends65129953re_n__ds
rennases848983rennases
reparks13249513re_parks
rereads81512293rerea_ds
rerewards1344643rerewards
restarts8310873restarts
retard75018933re_tard_
retears72814923retear_s
reward106017643re_ward_
rewarms12439603re_warms
rewears102911043rewear_s
rewords115413983re_words
ritards8439943r_itards
rynds9569973r_yn__ds
seawards1237203seawards
skywards1943373skywards
tanyards1276183tanyards
yards95324613__y_ards

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 Filter1786911461620.420425454.8
2DLD Change Limit146162787.86018595.7
3Display Results78780.0332363.6
 (SQL Overall)178691788.31321495.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.