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

55 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
deraigning134410(None) 
arraigning1242782arraigning
deigning1137752de__igning
derailing112011312derai_ling
deranging1238062derang_ing
designing1236622de_signing
detaining112510472detai_ning
detraining1267672detrai_ning
draining103312672d_rai_ning
braining113414683_brai_ning
deaconing1337193de_aconing
deadening1277583de_adening
deafening1476273de_afening
deairing10311893de_ai_ring
deaning94020473de_a__ning
debagging1533593deba_gging
declining13129353decli_ning
defanging1535333defang_ing
defining133711803de_fi_ning
defragging1742823defra_gging
depainting14156153depainting
deraign936573deraig__n_
deraigned1244093deraign_ed
deraigns1034883deraig__ns
derating103222283dera__ting
deratting1139513dera_tting
deriding112512933der_i_ding
deriving132510743der_i_ving
designings1342623de_signings
destaining1267943destai_ning
destining11311433desti_ning
detailing112510413detai_ling
deveining1436393devei_ning
dragging12308103d_ra_gging
draggling1354613d_raggling
eloigning1143453_eloigning
feigning1335813fe__igning
graining102813183_grai_ning
pertaining1347993pertai_ning
raining83922693__rai_ning
realigning1245933realigning
refraining1437263refrai_ning
regaining112411083regai_ning
reigning1039883__reigning
remaining122212793remai_ning
reraising10313773rerai_sing
rerigging1236553rer_igging
resigning1139463re_signing
retaining102114733retai_ning
retraining11310243retrai_ning
scraighing1742933scraighing
spraining1248153sprai_ning
straining10410563strai_ning
training93015863_trai_ning
undersigning1553463undersigning

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 Filter1786911406030.406440125.6
2DLD Change Limit140603555.89023871.5
3Display Results55550.0163437.5
 (SQL Overall)178691556.31228309.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.