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

58 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
precrease134523(None) 
precreased1544411precreased
precreases1445651precreases
decrease1136562_decrease
precieuse1344612precieuse
precrash1544822precr_ash
procreate1348142procreate
recreate10313602_recreate
crease85519573___crease
decease1049523_dec_ease
decreased1345453_decreased
decreases1237223_decreases
degrease1045413_degrease
increase1066453_increase
pancreas1235393pancreas_
pancreases1443763pancreases
pectase112410363p_ec_tase
permease1246503p_ermease
precast11314853prec__ast
precavae1544813precava_e
precede1239653prec_e_de
precedes13310713prec_edes
precess11310863prec_e_ss
precessed1437523prec_essed
precesses13310463prec_esses
prechoose16105633prechoose
prechose15129773prec_hose
precise113518173prec__ise
preclean1245893preclea_n
precleaned1543803precleaned
precleans1344893precleans
preclear1245423preclea_r
precleared1544113precleared
preclears1344373preclears
precreasing1645703precreasing
precures12312903precure_s_
predecease1543523predecease
prefreeze2342093prefreeze
prepense12238943pre_pense
prepregs13144763prepregs_
prepress12137983prepre_ss
prerace11414123pre_r_ace
prerelease1252913prerelease
prerinse1038633pre_rinse
pretense10199823pre_tense
pretreat10311923pretrea_t
pretreated1347623pretreated
pretreats1146933pretreats
procreant1346253procreant
procreated1546443procreated
procreates1448153procreates
protease10209893pr_otease
recrate92621663_recr_ate
recreance1346993_recreance
recreant10311283_recreant
recreated12412533_recreated
recreates11313363_recreates
release7312763_re_lease

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.423422437.4
2DLD Change Limit148641586.86021667.8
3Display Results58580.0301933.3
 (SQL Overall)178691587.31324434.7
 
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.