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

57 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
redistribution1717348(None) 
redistributions18223401redistributions
distribution1555362__distribution
redistributing1862672redistributing
redistributive2072382redistributive
distributions1665123__distributions
maldistribution201603963maldistribution
misdistribution20162143misdistribution
reattribution15112523re_attribution
redistribute15133013redistribut__e
redistributed17122673redistribut_ed
redistributes16122853redistribut_es
retribution13114983re___tribution
distributing1654744__distributing
distributional1762964__distributional
distributive1853724__distributive
distributor1453554__distribut_or
reattributions16112424re_attributions
redescription1862744redescri_ption
redistillation1563034redistillation
redistricting1753784redistri_cting
registration1347534registr__ation
restitution1175974re__st_itution
restriction1349364re__stri_ction
retributions14134944re___tributions
attribution1353685___attribution
contribution1655095__contribution
destitution1255545__dest_itution
distinction1447325__dist_inction
distraction1449115__distr_action
distributary1862345__distributary
distribute13145525__distribut__e
distributed15144755__distribut_ed
distributee14124925__distribut_ee
distributees15143365__distributees
distributes14135285__distribut_es
distributors1553035__distributors
misattribution18122485misattribution
predestination1765485predest_ination
reattributing1692115re_attributing
reconstitution1663565reconst_itution
redescriptions1962785redescri_ptions
redintegration16153645redintegration
redirection1446055redi__r_ection
redisposition16103125redis_position
redistillations1672915redistillations
redistrict1355705redistri_ct___
redistricted1652965redistri_ct_ed
redistricts1453665redistri_ct__s
registrations1446895registr__ations
reintroduction1762375re_introduction
repatriation14126975re_patri_ation
repristination16204105reprist_ination
restitutions1275705re__st_itutions
restrictions1449285re__stri_ctions
retributive1653515re___tributive
undistributed1762245undistribut_ed

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 Filter178691950240.360496363.9
2DLD Change Limit95024576.31315052.1
3Display Results57570.0461239.1
 (SQL Overall)178691576.71926594.9
 
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.