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

76 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
photophases215794(None) 
photophase2057431photophase_
photophores2159102photophores
phosphates2087163pho_sphates
photoflashes2353073photoflashes
photolyses1846653photo_lyses
photomasks2153743photo_masks
photophore2058633photophore_
photopias16410143photopia__s
photoplays2054723photopla_ys
photospheres2255803photospheres
phototaxes2246663photo_taxes
prophases16411063p__rophases
protoplasms1764873protoplasms
protoplasts1566053protoplasts
apophases1647974__apophases
diplophases1953214diplophases
holophytes2185784_holophytes
homophiles2048224_homophiles
homophobes2246564_homophobes
homophones2048384_homophones
homoplasies18105254_homoplasies
hypophyses2646054_hypophyses
leptophoses1853904leptophoses
metaphases1745064_metaphases
philosophises23144154philosophises
phosphatases2262934pho_sphatases
phosphate1977274pho_sphate_
phosphenes2076554pho_sphenes
phosphides2175364pho_sphides
phosphines20116404pho_sphines
phosphites2087044pho_sphites
phosphores2078424pho_sphores
photocopies2058914photocopies
photodiodes1853854photodiodes
photoflash2153534photoflas_h
photogenes1648884photo_genes
photograms1848194photogra_ms
photographs22411474photographs
photokineses2153674photokineses
photolysis1846704photo_lysis
photolyzes2745484photo_lyzes
photomaps1845604photo_ma_ps
photomask2054124photo_mas_k
photophobia2355614photophobia
photophobias2455124photophobias
photophobic2555794photophobic
photopia1549734photopia___
photoplay1954754photopla__y
photoscans1755464photosca_ns
photoset13414284photo___set
photosets1447834photo___sets
photosphere2155924photosphere_
photostated1765864photostated
photostats1547064photosta_ts
phototaxies2356224phototaxies
phototaxis2256504photo_taxis
phototubes1754364photo_tubes
phototypes2046514photo_types
phthises1645724ph_t__hises
phytophagous2662314phytophagous
polyphase1945094p_olyphase_
prophages1749764p__rophages
prophase15410244p__rophase_
protases102115034prot___ases
proteases112110834prot__eases
proteinases1344524proteinases
protheses1449074prot__heses
protonates12411694proto_nates
protophloem2072944protophloem
protophloems2162024protophloems
protoplanet1566584protoplanet
protoplanets1663664protoplanets
protoplasm1665324protoplas_m
protoplast1467784protoplas_t
telophases1545914_telophases

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.453394461.4
2DLD Change Limit148819768.92316678.1
3Display Results76760.0461652.2
 (SQL Overall)178691769.42218965.3
 
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.