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

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

78 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
photically2041116(None) 
phatically20411311phatically
phonically2049021phonically
aphetically2159242aphetically
chaotically2148432chaotically
erotically15414292erotically
exotically2249472exotically
phonetically2249082phonetically
physically2346092physically
poetically17412872poetically
thetically18410482thetically
abiotically1849063abiotically
alogically1648773alogically
anodically1648233anodically
antically14315673_antically
arctically17410353arctically
atomically1749833atomically
chemically2248313chemically
chronically2147793chronically
comically18310513_comically
conically16312813_conically
cortically17411803cortically
critically17411263critically
dichotically2356223dichotically
domically1749093_domically
emetically17411413emetically
emphatically2456423emphatically
euphonically2254593euphonically
euphorically2254603euphorically
gothically1946693_gothically
hectically2049603hectically
helically1749433_helically
hypnotically2555623hypnotically
iconically1769273iconically
idiotically1747513idiotically
ironically151110533ironically
logically1548963_logically
lytically1757373_lytically
meiotically1849753meiotically
mitotically1849103mitotically
myopically2246163myopically
mystically2048123mystically
nautically1548833nautically
ohmically1946893oh_mically
ontically14311833_ontically
optically1649883_optically
osmotically1847753osmotically
panically16310433p_anically
partially1449033parti_ally
pathetically2249203pathetically
phallically2154413phallically
phonemically2456183phonemically
photocell1654103photocell_
photocells1754553photocells
phyletically2555933phyletically
piratically18411203piratically
plastically1849393plastically
politically18411463politically
practically20410443practically
prodigally1744383prodigally
prosaically1847843prosaically
proximally2443783proximally
psychotically2855813psychotically
publically1944863publically
robotically1868493robotically
rustically1548973rustically
sonically14310933_sonically
spastically1848733spastically
spherically2146933spherically
statically15411563statically
stoically1449643sto_ically
tactically1749743tactically
tonically14311123_tonically
topically1649523_topically
toxically2147563_toxically
tropically1749823tropically
vertically18410913vertically
vortically1849173vortically

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 Filter1786911406030.1531167915.0
2DLD Change Limit140603788.92315757.4
3Display Results78780.0332363.6
 (SQL Overall)178691789.10919617.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.