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

62 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
photometrically2764061photometrically_
bolometrically2363664_bolometrically_
econometrically24133344econometrically_
photogenically2564794photoge_nically_
photolytically2774264photolyt_ically_
pyrometrically2654754p_yrometrically_
barometrically2353915_barometrically_
coulometrically2462485coulometrically_
eudiometrically2362545eudiometrically_
geometrically2155495__geometrically_
heliometrically2562695heliometrically_
isometrically2054955__isometrically_
manometrically2354015_manometrically_
parametrically2354475p_arametrically_
phonetically2249085ph__onet_ically_
photochemically3264085photochemically_
photometric2058585photometric_____
phototactically2762785phototactically_
phototropically2763345phototropically_
planimetrically2462225planimetrically_
radiometrically2372825radiometrically_
volumetrically2462425_volumetrically_
apologetically2254146apologet_ically_
arithmetically2453856arithmet_ically_
asymmetrically2663156_asymmetrically_
automatically2077406_automat_ically_
bathymetrically3062156bathymetrically_
chimerically2455006ch__ime_rically_
cholerically2256156ch__ole_rically_
chromatically2556936ch_romat_ically_
chronometrical2372276chronometrica_l__
cosmetically2147916_co_smet_ically_
diametrically2154506__diametrically_
esoterically17126106esot__e_rically_
exoterically24135756exot__e_rically_
gravimetrically2691916gravimetrically_
hermetically2248376_h_ermet_ically_
metamerically2254406_metame_rically_
metrically17411076_____metrically_
motorically1849416_moto___rically_
obstetrically2053056__obstetrically_
pathetically2249206p_at_het_ically_
phlegmatically27103506phlegmat_ically_
phonemically2456186ph__one_mically_
phonogramically2862846phonogramically_
phonologically2555516phono_logically_
photically20411166ph__o__t_ically_
photometries1968316photometri____es
photometry2056466photometr_____y_
phyletically2555936ph__ylet_ically_
phytochemically3563796phytochemically_
poetically17412876p___o_et_ically_
prophetically2577456pro_phet_ically_
prosthetically2454606prosthet_ically_
proteolytically2562446proteolyt_ically_
prototypically2662676proto_typically_
rhetorically2065856rheto___rically_
symmetrically2554366__symmetrically_
telemetrically2163396_telemetrically_
theoretically2186236th_eoret_ically_
tonetically16410796___tonet_ically_
unsymmetrically2772136unsymmetrically_

Search took 6 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 Filter178691658740.0931921408.6
2DLD Change Limit65874624.89313462.9
3Display Results62620.0461347.8
 (SQL Overall)178691625.03235510.9
 
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.