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

40 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
prescript154703(None) 
prescripts1644741prescripts
rescript1277421_rescript
prescribe15106672prescribe
rescripts1374572_rescripts
adscript1344203_adscript
conscript1547123conscript
coscript1456633_coscript
frescoist1444123frescoist
postscript16123643postscript
precept133112513pre_c_ept
precipe133012123pre_c_ipe
preprint12314183pre_print
preriot9316413pre__riot
prescient13411323prescient
prescind1338393presc_ind
prescoring1547433prescoring
prescreen1345103prescreen
prescribed17105373prescribed
prescriber1684883prescriber
prescribes16106283prescribes
prescription18145343prescription
prescriptive2153233prescriptive
preship1439793pres_hip_
preships1539313pres_hips
preshrink1844773preshrink
presift12312223pres__ift
presort95219543presor__t
presplit1247753prespli_t
prestrike1547493prestrike
preterit10315843preteri_t
proscribe1585623proscribe
receipt1159253_re_ceipt
resculpt1245323_resculpt
restrict10313633_restrict
script105717903___script
subscript1544663subscript
superscript1785833superscript
transcript1456473transcript
typescript1961893typescript

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 Filter1786911486410.423422437.4
2DLD Change Limit148641407.96618659.4
3Display Results40400.0162500.0
 (SQL Overall)178691408.40521260.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.