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

60 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
keystones164508(None) 
keystone1545331keystone_
eyestones1246322_eyestones
felstones1246962felstones
gemstones1245562gemstones
ketones115014502ke__tones
keystrokes1652122keystrokes
burstones1187153burstones
capstones1347373capstones
centones10313663ce_ntones
cestodes1138203ce_stodes
claystones1544393claystones
cystines1339473_cystines
destines93619663de_stines
drystone1245123drystone_
earstones948523earstones
ecotones1039493_ecotones
estrones8313323_e_strones
eyestone1146533_eyestone_
felstone1146863felstone_
freestones1345703freestones
gemstone1145843gemstone_
headstones1465363headstones
histones11312803_histones
holystones1655243holystones
inkstones1345083inkstones
keeshonds1742583keeshonds
kelsons1137323kels_on_s
keratoses1346093keratoses
ketenes114813503ke__tenes
ketone105014533ke__tone_
ketoses114912873ke__toses
keyholes1844593key_holes
keynotes1543633key_notes
keyster14256153keyst__er
keysters15326333keyst_ers
keystroke1552283keystroke_
keystroked1751643keystroked
klystrons1642363klystron_s
kryptons1743223krypton_s
mudstones1245033mudstones
neustons836833neuston_s
oestrones949773oe_strones
oilstones946613oilstones
oxytones1844053oxy_tones
pensiones11410003pensiones
peptones12311033pe_ptones
potstones1149213potstones
restokes125213043re_stokes
restores85222993re_stores
semitones1148943semitones
sestines82717243se_stines
stones65130033___stones
sunstones947883sunstones
systoles1146483_systoles
testons7313563te_ston_s
tinstones948493tinstones
topstones1147013topstones
veinstones1363733veinstones
whetstones1643343whetstones

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 Filter1786911486410.423422437.4
2DLD Change Limit148641609.10616323.4
3Display Results60600.0461304.3
 (SQL Overall)178691609.57518662.2
 
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.