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

64 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
photofinishing267171(None) 
photofinishings2781211photofinishings
photofinisher2471743photofinish_er
photofinishers2571333photofinishers
photoionizing2864064photoioni_zing
astonishing1553365_asto__nishing
finishing1645845_____finishing
homogenising19103125_homogenis_ing
photographing2565985photo_graphing
photokinesis2153555photokines_i_s
photooxidizing3772085photooxidi_zing
premonishing2053425premo__nishing
refinishing1843715___refinishing
stonishing1444915__sto__nishing
admonishing1852746_admo__nishing
bonefishing2052626_bonef__ishing
botanising1345956_bot__anis_ing
colonising1347646_colo__nis_ing
cutinising1345616_cut__inis_ing
diminishing1853256___diminishing
hominizing2546436_h__omini_zing
homogenizing2893806_homogeni_zing
minishing1547076_____minishing
monishing1547546___mo__nishing
motorising1347516_moto__ris_ing
nonvanishing1951806_no_nvanishing
outfishing1765996__outf__ishing
ozonising1944336__ozo__nis_ing
pathfinding2151916p_athfin__ding
patinizing2248616p_at__ini_zing
patronising1465246p_at_ronis_ing
peptonizing2546156pepto__ni_zing
photocomposing2672186photocomposing
photocopying2563746photo__copying
photoemission2062846photo_emission
photoemissions2162476photo_emissions
photoemissive2392196photo_emissive
photoengraving24112116photoengraving
photoflash2153536photof_lash___
photoflashes2353076photof_lash_es
photoing1439076photo______ing
photokineses2153676photokines__es
photokinetic2374346photokin_eti_c
photolyzing2953876photo___lyzing
photomapping2162476photo__mapping
photoreducing2262806photo_reducing
photoscanning2161946photo_scanning
photosensitive22183426photosensitive
photosensitize28203846photosensitize
photosetting1854256photo__setting
photostating18135846photo__stating
photostatting1993376photo_statting
planishing1645326p____lanishing
platinizing2346136plat__ini_zing
plenishing1644696p____lenishing
polishing1536926p___o__lishing
politicising1753506p_oliticis_ing
pollinizing2345076p_o_llini_zing
propositioning1972796propositioning
protonating1448596proto__n_ating
punishing1545386p_____unishing
sportfishing2161476sportf__ishing
tarnishing1445156___t_arnishing
whooshing1943216who_o____shing

Search took 10 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 Filter1786911247900.390458182.1
2DLD Change Limit124790649.41013261.4
3Display Results64640.0431488.4
 (SQL Overall)178691649.84318154.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.