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

71 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
sporophores185516(None) 
sporophore1754861sporophore_
sporophytes2154982sporophytes
aerophores1548583_aerophores
gonophores1646323_gonophores
ionophores1546643_ionophores
lophophores2153653lophophores
photophores2159113photophores
siphonophores23101553siphonophores
sporophylls21143633sporophylls
sporophyls20144163sporoph_yls
sporophyte2054853sporophyte_
acrophobes1945824_acrophobes
aerophobes1746534_aerophobes
aerophore1448244_aerophore_
agoraphobes1992064agoraphobes
carpophores2054134carpophores
chromophores2454244chromophores
ctenophores1853844ctenophores
foreshores16107404_foreshores
gonophore1546214_gonophore_
gonopores1246524_gonop_ores
gynophores1954544_gynophores
homophobes2246574_homophobes
homophones2048394_homophones
hydrophones2356384hydrophones
iodophors1543964_iodophor_s
ionophore1446624_ionophore_
loopholes1448894_lo_opholes
lophophore2053524lophophore_
microphones2048764microphones
micropores16610184microp_ores
morphoses1648124_mor_phoses
negrophobes1953704negrophobes
phosphores2078424_phosphores
photophore2058634photophore_
poechores1647954_po_echores
polyphones2046964_polyphones
polypores1648004_polyp_ores
porphyries2064904_por_phyries
portholes14410374_por_tholes
prophages1749764_p_rophages
prophases16411064_p_rophases
propones122516964_p_rop_ones
proposes122515974_p_rop_oses
proptoses1349874_p_roptoses
pyrophoric2256374_pyrophoric
saprophytes2154574saprophytes
saxophones2244434s_axophones
semaphores1744674s_emaphores
shorthorns1643614shor_thorns
siphonophore2271584siphonophore_
smoothbores1851334smo_othbores
sophomores1752664sopho_mores
soroches1338804s_oroch__es
spermatophores23152324spermatophores
spermophiles2153074spermophiles
spirochetes1852744spirochetes
sporangiophores23191104sporangiophores
sporocarps1652494sporo_carps
sporogonies1453524sporogonies
sporophyl19143854sporoph__yl
sporophyll20153754sporoph_yll
sporophytic2354504sporophytic
sporozoans21122764sporo_zoans
sporozoites2252224sporozoites
strophes13310604s_troph__es
strophoids1655524s_trophoids
trochophores2263094trochophores
zoochores2345954_zo_ochores
zoophobes2545284_zo_ophobes

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 Filter1786911488190.406440125.6
2DLD Change Limit148819718.54617413.9
3Display Results71710.0461543.5
 (SQL Overall)178691718.99819859.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.