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

51 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
precensor134525(None) 
precensors1445461precensors
precentor1348731precentor
recensor1045541_recensor
precensored1653142precensored
precentors1488342precentors
preceptor1547322preceptor
precursor1342922precursor
processor1346232processor
recensors1176132_recensors
censor84011293___censor
licensor10113723_licensor
percussor1342913percussor
precancer1547093precancer
precensoring1753223precensoring
precent113520263precen__t
precented14310693precented
precents123015043precen_ts
preceptors1657053preceptors
preceptory1945483preceptory
precess11310863prece_s_s
precessed1437523precessed
precesses13310463precesses
precession1448823precession
preciser123411663prec_iser
precursors1442813precursors
precursory1752053precursory
predecessor16131993predecessor
preener93114833pre_en_er
preens85020113pre_ens__
prehension1546313prehension
prelector1348093prelector
prepense12238943prepens_e
preseason1144123preseason
presenter11311643presenter
pressor93512883pr__essor
pretender1246663pretender
pretense10199823pretens_e
pretenses112210593pretenses
pretension1247533pretension
preventer1438593preventer
previsor13116303pre_visor
processer1346893processer
processors1446433processors
professor1445033professor
recension1148863_recension
recensored1344253_recensored
recenter102715443_recenter
receptor1256693_receptor
trecento1066213trecento_
trecentos1155873trecentos

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 Limit148641517.43619989.4
3Display Results51510.0331545.5
 (SQL Overall)178691517.89222642.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.