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

34 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
challengingly23692(None) 
challenging1852562challenging__
chillingly1943364chill___ingly
rechallenging2071274rechallenging__
unchallenging2081124unchallenging__
alleging1038475__alle_ging__
alluringly1443415__all_uringly
calmingly1745615c_a_l__mingly
caressingly1752955c_a_ressingly
challenge1543625challe___ng_e
challenged1742525challe___nged
challenger1652695challe___nger
challengers1752505challeng__ers
challenges1643995challe___nges
changing153211515cha___nging__
charmingly2143415cha___rmingly
chastening1656525chasten_ing__
clankingly2043305c___lankingly
clatteringly1852465clatte_ringly
collegially1753415c_olle_gially
consentingly1854665c_onsentingly
deadeningly1752645dea_den_ingly
deafeningly1952545dea_fen_ingly
falteringly1843145_falte_ringly
gallingly1435855_gall___ingly
haltingly1645695_ha_l__tingly
hauntingly1743805_ha__untingly
hearteningly1972435hearten_ingly
hedgingly1843575_h___edgingly
longingly1445335____longingly
maddeningly1951545_madden_ingly
shatteringly1962385shatte_ringly
unchangingly2252185uncha___ngingly
unrelentingly1762525unrelentingly

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.390458182.1
2DLD Change Limit124790348.34314957.4
3Display Results34340.0331030.3
 (SQL Overall)178691348.76620384.6
 
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.