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

56 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
praecipes154485(None) 
praecipe1444631praecipe_
precipes143212211pr_ecipes
graecizes2144572graecizes
precipe133012122pr_ecipe_
precises123218332pr_ecises
recipes113314462_r_ecipes
francizes2346793francizes
graciles112511613gra_ciles
graecize2044763graecize_
graecized2243573graecized
grecizes2035683gr_ecizes
panpipes1135173p_anpipes
parecisms1547163parecisms
piracies12312643pira_ci_es
practices1557993practices
practises1349623practises
prairies10411453prairi_es
praises94121103pra__ises
pralines102217723pra_lines
prances113618773pranc__es
praxises1739063pra_xises
preaches153214893preac_hes
precedes13310713pr_ecedes
precepts14268893pr_ecepts
precious12310593pr_ecious
precipices1845513pr_ecipices
precis103416703pr_eci__s
precise113518173pr_ecise_
precised133213413pr_ecised
preciser123411663pr_eciser
precisest13259003pr_ecisest
precited133013813pr_ecited
precodes13711573pr_ecodes
precures12312903pr_ecures
preemies12512193preemi_es
preexcites2144163preexcites
prefiles133113443pr_efiles
prefires134313283pr_efires
prefixes20389233pr_efixes
prelives13310383pr_elives
premies113823063pr_emi_es
premises123018273pr_emises
premixes193110083pr_emixes
preppies1149693pr_eppies
presides11414913pr_esides
pretapes122811533pr_etapes
pretypes15337263pr_etypes
previses133814283pr_evises
prewires133811013pr_ewires
prexies163415003pr_exi_es
principe1445683principe_
principles1643843principles
rareripes1165353_rareripes
recipe103414893_r_ecipe_
recites93524583_r_ecites

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 Filter1786911486410.516346300.4
2DLD Change Limit148641567.11020905.9
3Display Results56560.0301866.7
 (SQL Overall)178691567.65623340.0
 
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.