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

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

87 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
photophores215910(None) 
photophore2058631photophore_
phosphores2078422pho_sphores
photophases2157942photophases
photospheres2255802photospheres
chromophores2454243chromophores
gonophores1646323_gonophores
homophobes2246563_homophobes
homophones2048383_homophones
ionophores1546643_ionophores
phosphore1967893pho_sphore_
phosphors1976543pho_sphor_s
phosphorus2084823pho_sphorus
photodiodes1853853photodiodes
photophase2057433photophase_
photophobia2355613photophobia
photophobias2455123photophobias
photophobic2555793photophobic
photosphere2155923photosphere_
siphonophores23101553siphonophores
sporophores1855153sporophores
aerophores1548574_aerophores
carpophores2054124carpophores
chromatophores2672004chromatophores
chromophore2354154chromophore_
ctenophores1853834ctenophores
gametophores2062494gametophores
gonophore1546214_gonophore_
gonopores1246524_gonop_ores
gynophores1954544_gynophores
holophytes2185784_holophytes
homophiles2048224_homophiles
homophobe2146154_homophobe_
homophone1947844_homophone_
homophonies2156514_homophonies
hoopoes121212484_ho_op_o_es
iodophors1543964_iodophor_s
ionophore1446624_ionophore_
leptophoses1853904leptophoses
loopholes1448894_lo_opholes
lophophores2153644lophophores
notochords1672744_notochords
phosphates2087164pho_sphates
phosphenes2076554pho_sphenes
phosphides2175364pho_sphides
phosphines20116404pho_sphines
phosphites2087044pho_sphites
phosphor1865104pho_sphor__
phosphoresce2462714pho_sphoresce
phosphori1966294pho_sphor_i
phosphoric2266444pho_sphoric
phosphorites2254694pho_sphorites
phosphorous2173944pho_sphorous
phosphoruses2253844pho_sphoruses
phosphoryl2353784pho_sphoryl
phosphoryls2453274pho_sphoryls
photocathodes2462374photocathodes
photocopies2058914photocopies
photodiode1754104photodiode_
photofloods2052444photofloods
photogenes1648884photo_genes
photolyses1846654photo_lyses
photolyzes2745484photo_lyzes
photometers1848444photometers
photometries1968334photometries
photopias16410144photop__ias
photoplays2054724photop_lays
photospheric2455134photospheric
phototaxes2246664photo_taxes
phototaxies2356224phototaxies
phototubes1754364photo_tubes
phototypes2046514photo_types
phytochromes2763004phytochromes
poechores1647954p_o_echores
polyphones2046964p_olyphones
polypores1648004p_olyp_ores
potholes13312934p_ot__holes
protophloem2072944protophloem
protophloems2162024protophloems
protopods1446994protop_o_ds
protostomes1555804protostomes
shotholes1546184shot__holes
siphonophore2271584siphonophore_
sporophore1754864sporophore_
trochophores2263084trochophores
zoochores2345954_zo_ochores
zoophobes2545284_zo_ophobes

Search took 9 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 Filter1786911488190.420425454.8
2DLD Change Limit148819877.95318712.3
3Display Results87870.0461891.3
 (SQL Overall)178691878.41921224.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.