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 “photoreductionsa” with Change Limit: [1] [2] [3] [4] [5] [6] [7]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

34 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
photoreductions23153341photoreductions_
photoreduction2283712photoreduction__
photoinductions23102743photoinductions_
photoreactions21113563photore_actions_
photoinduction22103004photoinduction__
photoproduction2573064photoproduction__
photoreaction20134174photore_action__
photoreceptions2473354photoreceptions_
photoreducing2262804photoreduc_i_n_g
photoelectrons2173375photo_electrons_
photoreception2373785photoreception__
photoreduces2072965photoreduc___es_
postproductions2272505postproductions_
coproductions2054496_co_productions_
introductions1655136_int_roductions_
overeducations2054986__overeducations_
photodetectors22102256photodetect_ors_
photoelectron2063786photo_electron__
photoelectronic2472546photo_electronic
photoemissions2162476photo_emissions_
photoinductive2572196photoinducti__ve
photooxidations2872746photooxidations_
photoproducts2362396photoproduct___s_
photoreceptors2392656photorecept_ors_
photoreduce1962836photoreduc_____e
photoreduced2162246photoreduc____ed
postproduction2162896postproduction__
predictions1649656p____redictions_
preproductions2153946p_reproductions_
productions1647536p____roductions_
protections15510706prot__e__ctions_
protractions1646646prot_r__actions_
putrefactions2052276p_ut_refactions_
reductions1359586_____reductions_

Search took 6 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 Filter178691658740.330541487.9
2DLD Change Limit65874345.15612776.2
3Display Results34340.0301133.3
 (SQL Overall)178691345.51632395.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.