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

54 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
keyword184456(None) 
keywords1944321keywords
byword1535052_byword
keyboard1844502keyboard
keycard1743662keycard
reword106321412re_word
baywood1646443baywood
bedward1497473bedward
beworm1339993be_worm
beyond1237073bey_ond
bywords1634283_bywords
bywork1834863_bywork
daywork1845653daywork
deworm1249533de_worm
dyewood1554143dyewood
eelworm1245523eelworm
felwort13410583felwort
hayward1736413hayward
headword1645523headword
kayoed14416903kay_oed
keloid11812623ke_loid
keyboards1943963keyboards
keycards1843063keycards
keyed1369393key__ed
keyhole1764433keyhole
keynote1443903keynote
keynoted1642783keynoted
keypad1633823key_pad
keyway1943823keyw_ay
keyways2043373keyways
leeward1135783leeward
legwork1545663legwork
misword1338413misword
network1446803network
nonword1149153nonword
overword15119243overword
plywood1645133plywood
record96117433re_cord
redwood1236523redwood
reward106017643re_ward
rewords115413983re_words
rewore938030163re_wore
rework136619793re_work
reworn98122203re_worn
reynard1135123reynard
seaward1148183seaward
skyward1843863skyward
sword95214123__sword
telford1145153telford
wayward1736053wayward
wayworn1675293wayworn
webwork1944843webwork
webworm1744313webworm
word89832003___word

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 Filter1786911340270.390458182.1
2DLD Change Limit134027546.97019229.1
3Display Results54540.0163375.0
 (SQL Overall)178691547.37624226.0
 
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.