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 “predecessors” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

32 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
predecessors1712162(None) 
predecessor16131991predecessor_
precensors1445463pr__ecensors
predeceases1653623predeceas_es
preprocessors1962483preprocessors
processors1446433pr__ocessors
redressors1153783_red_ressors
antecessors1352364_antecessors
percussors1452804p_e_rcussors
precensor1345254pr__ecensor_
precentors1488344pr__ecentors
preceptors1657054pr__eceptors
precesses13310464pr__ecess_es
precessions1548554pr__ecessions
precursors1442814pr__ecursors
predaceous1553944predace__ous
predecease1543524predeceas__e
predeceased1752984predeceas_ed
predeceasing18103064predeceasing
predictors1547264predic__tors
prelectors1447874prelec__tors
preprocessor1862744preprocessor_
prerecession1683574prerecession
pressors103212694pr____essors
processers1446004pr__ocessers
processor1346234pr__ocessor_
professors1555254pr__ofessors
recensors1176134_r__ecensors
redressers1145104_red_ressers
redressor1064224_red_ressor_
regressors1154254_re_gressors
repressors1265774_re_pressors

Search took 8 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.376475242.0
2DLD Change Limit124790327.28017141.5
3Display Results32320.0162000.0
 (SQL Overall)178691327.67223291.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.