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

45 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
keycards184306(None) 
keycard1743661keycard_
keyboards1943962keyboards
keypads1743342keypa_ds
keywords1944322keywords
reynards1244302reynards
bayards13379683bay_ards
beards94116673be__ards
bedwards1596393bedwards
beeyards1444593beeyards
boyards13399323boy_ards
cards85137933___cards
cycads14476213_cyca_ds
daycares1454803daycares
debeards1235503debeards
decares102818533de_cares
discards1238913discards
echards1337963_echards
escarps11397373_escarps
escars83913133_escar_s
haywards1845873haywards
jeopards1843683jeopards
kaleyards1773293kaley_ards
kebars124112493ke_bar_s
keyboard1844503keyboard_
keypad1633823keypa_d_
keypals1634353keypa_ls
keyways2043373keywa_ys
keyword1844563keyword_
kyars124813963k_y_ar_s
leewards1244983leewards
leopards1144753leopards
leotards945303leotards
petards104311153pe_tards
placards1345813placards
reboards1138773reboards
records105213923re_cords
regards94112563re_gards
retards85015003re_tards
rewards114813993re_wards
reynard1135123reynard_
seawards1237203seawards
skywards1943373skywards
teacarts10116073teacarts
yards95324613__y_ards

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 Filter1786911461620.423422437.4
2DLD Change Limit146162456.29623215.1
3Display Results45450.0162812.5
 (SQL Overall)178691456.73526531.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.