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

65 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
photocomposers2534284(None) 
photocomposer24413881photocomposer_
photocomposes24344721photocompose_s
photocompose23414292photocompose__
photocomposed25383492photocompose_d
photocomposing2672183photocomposing
photocopiers2154963photoco_p_iers
cocomposers1952644___cocomposers
noncomposers1853284_no_ncomposers
photocopier2066494photoco_p_ier_
photocopies2058914photoco_p_ie_s
cocomposer1853325___cocomposer_
composers153910625_____composers
decomposers1852505___decomposers
noncomposer1753725_no_ncomposer_
photocathodes2462375photocathode_s
photocopied2156395photoco_p_ie_d
photographers2457175photograp_hers
photometers1848445phot__om_eters
photopolymers2572245photopo_lymers
composer145012956_____composer_
composes145017116_____compose_s
composters16388326_____composters
decomposer1753496___decomposer_
decomposes1745196___decompose_s
discomposes1854126__discompose_s
homecomers1954026_homecom___ers
microcomputers24202186microcomputers
phagocytoses2362366phagoc_ytose_s
phenocopies2055866phenoco_p_ie_s
philosophers22143306philoso_p_hers
phonographers2465806phonograp_hers
photocathode2362696photocathode__
photochemistry29103436photochemistry
photochemists2584816photochemis_ts
photochromisms2872926photochrom_is_ms
photocopy2155646photoco_p____y
photocopying2563746photoco_p_ying
photodiodes1853856phot__odiode_s
photoengravers2391666photoengravers
photofinishers2571336photofinishers
photographer2349696photograp_her_
photographies2459416photographie_s
photoionizes2655306photoio_nize_s
photokineses2153676photo_kinese_s
photolyses1846656phot__o_lyse_s
photomasks2153746phot__om_as_ks
photometer1749226phot__om_eter_
photomontages2162736photomontage_s
photomosaic2054096phot__om_osaic
photomosaics2163156phot__om_osaics
photophases2157946phot__ophase_s
photophores2159106phot__ophore_s
photopolymer2482696photopo_lymer_
photosets1447836phot_____osets
photosetters1773926phot__osetters
photosphere2155926phot__osp_here
photospheres2255806phot__osp_heres
phototropisms2264686phototropis_ms
phototypes2046516photo_typ__e_s
phytochromes2763006phytoc_hrome_s
phytohormones2671736phytohormone_s
potometers1449066p_ot__om_eters
proposers13228526p____ro_posers
recomposes1646066___recompose_s

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 Limit124790659.45313201.1
3Display Results65650.0461413.0
 (SQL Overall)178691659.88918069.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.