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

46 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
frighteningly241190(None) 
frightening1982682frightening__
brightening18102573brightening__
frighting1736024fright__ing__
heightening1952674heightening__
lightening15255054_lightening__
slightingly1952274slight__ingly
tightening15153944_tightening__
blisteringly1852295bli_steringly
driftingly1843675dri_ft__ingly
enlightening1751725enlightening__
falteringly1843155f__alteringly
fighting162710085f_ight__ing__
fightings17276505f_ight__ing_s
fittingly1645275f_i__t_tingly
flatteringly1952565f_latteringly
flichtering2042685flichtering__
flickeringly2561235fli_ckeringly
flightily1943355flight__i__ly
flighting1736105flight__ing__
freewheelingly277475freewheelingly
freezingly2643365fr___eezingly
freighting1844545freight__ing__
freshening1744775fresh_ening__
frighten1566445frighte__n___
frightened1843245frighte__n_ed
frightens1655395frighte__n__s
frightfully2452085fright__fully
frittering14105625fri_ttering__
frowningly2042845fr___owningly
glitteringly1751865gli_tteringly
grinningly1543375gri___nningly
hearteningly1972435_hearteningly
lightering15246115_lightering__
lightning14286025_light_ning__
lightninged1751375_light_ninged
lightnings15263805_light_ning_s
retightening1752065retightening__
richening1546225_rich_ening__
righteously1853185_righte_ously
righting132610855_right__ing__
rivetingly1743555_ri__vetingly
sickeningly2151795_si_ckeningly
straightening1862105straightening__
threateningly2061215threateningly
witheringly2152525_with_eringly

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.500357382.0
2DLD Change Limit124790468.04615509.6
3Display Results46460.0301533.3
 (SQL Overall)178691468.57620836.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.