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

43 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
prescinded164434(None) 
rescinded1335761_rescinded
prescind1338392prescin__d
prescinds1444952prescind_s
presided12410552pres_i_ded
rescinder1245292_rescinder
crescendoed1751273crescendoed
descended1446283_descended
exscinded2042223_exscinded
preceded1438293pre_c_eded
precented14310693pre_cented
precised133213413pre_ci_sed
precited133013813pre_ci_ted
precluded1544223pre_cluded
precoded1438863pre_c_oded
prefunded1644693pre_funded
preguided1443923pregui_ded
preprinted1546543preprinted
prerinsed1246323pre_rinsed
prescience16157293prescience_
presciences17127273presciences
prescinding1744853prescinding
prescored14409403presc_ored
prescribed17105373prescribed
presented12311633pres_ented
preshipped1742963preshipped
preside10715613pres_i_de_
presider11410423pres_i_der
presides11414913pres_i_des
presifted1536873pres_ifted
presliced1435983presli_ced
pretended1337193pre_tended
reascended1444363_reascended
reminded123411523_re_minded
rescind10410393_rescin__d
rescinders1344303_rescinders
rescinds1136333_rescind_s
reshined123011123_reshin_ed
resided95217703_res_i_ded
resined84522653_res_in_ed
resounded1136323_resounded
responded1336513_responded
rewinded13277673_re_winded

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 Filter1786911406030.423422437.4
2DLD Change Limit140603436.79620689.1
3Display Results43430.0162687.5
 (SQL Overall)178691437.23524698.1
 
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.