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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

101 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
pyrotechnically3072161pyrotechnically_
pyrotechnical2562433pyrotechnica_l__
pyrometrically2654765pyrome_trically_
pyrotechnic2352885pyrotechnic_____
pyrotechnics2462505pyrotechnic____s
technically2146445____technically_
biomechanically2971866_biomechanically_
biotechnical2162866_biotechnica_l__
cryogenically2453396cryoge__nically_
geotechnical2082386_geotechnica_l__
geotectonically23111606_geotectonically_
gyroscopically2762236gyro_scopically_
paratactically2353526paratac_tically_
parochially2153186paro__ch_i_ally_
photochemically3264096p_hotochemically_
photogenically2564816p_hotogenically_
proleptically2256006p_role_ptically_
proteolytically2562456p_roteolytically_
prototypically2662686p_rototypically_
puritanically2053756purit__anically_
pyrolytically2256096pyro__lytically_
pyrotechnist2282976pyrotechni____st
pyrotechnists23102296pyrotechni___sts
zootechnical2861956_zootechnica_l__
abiogenically2163847abioge__nically_
archaically2145827_ar___chaically_
barometrically2353927barome_trically_
botanically1847017__bot__anically_
bronchially2152507_bro_nch_i_ally_
chronically2147807chro____nically_
cytogenetically2662857cytogenetically_
epeirogenically23111867epeiroge__nically_
erotically15414317_erot____ically_
esoterically17126127_esote__rically_
estrogenically2093247estroge__nically_
ethnically1847837_____ethnically_
exoterically24135777_exote__rically_
gothically1946717__got__h_ically_
hydromechanical3181617hydromechanica_l__
hydronically2455247hydro____nically_
hydroponically2863207hydro__ponically_
hygienically2483387hy_gie__nically_
hypodermically3062177hypode_rmically_
hypothetically3064397hypot_hetically_
hysterically2354897hy_ste__rically_
iatrogenically20103447iatroge__nically_
irenically15710317_ir__e__nically_
ironically151110547_iro____nically_
isotonically1756057_isot__onically_
mechanically2455597____mechanically_
monogenically2154737monoge__nically_
monotonically2055327monot__onically_
moronically1849107moro____nically_
mythically2345847my__t__h_ically_
neurogenically2062967neuroge__nically_
nontechnical1963527_nontechnica_l__
paragenetically2362727paragenetically_
parametrically2354487parame_trically_
participially2271947par_ticipi_ally_
perennially1654607per__e_nni_ally_
phonemically2456207p_hone__mically_
phonetically2249097p_hone__tically_
phonically2049027p_ho____nically_
photically20411177p_hot____ically_
photolytically2774287p_hotolytically_
phototactically2762787phototac_tically_
phytochemically3563797p_hytochemically_
piratically18411227pirat____ically_
platonically1945907p_lat__onically_
poetically17412887p__o_e__tically_
polemically2047647p__ole__mically_
polyphonically2962167p__olyphonically_
potentially1656807p__ote__ntially_
practically20410447p_r__ac_tically_
problematically2662047p_roblematically_
prolifically2255487p_ro__lifically_
prophetically2577457p_ro_phetically_
prosaically1847847p_ro___saically_
prosodically2056587p_ro__sodically_
prosthetically2454617p_rosthetically_
protectively2254727p_rotec_ti_vely_
prothallia1553497p_rot__h___allia
proverbially2252127p_rove_rbi_ally_
provincially2253027p_ro__vincially_
psychically2654997p___sych_ically_
psychogenically3172377psychoge__nically_
pyrogenicity2364057pyroge__nic_ity_
strategically1954007strate__gically_
syntactically2354417sy_ntac_tically_
systematically2464107sy_stematically_
systemically2254157sy_ste__mically_
technical1646057____technica_l__
technicality2252727____technicality
technicalize2893077____technicalize
technicals1753957____technica_l_s
tectonically1946327____tectonically_
tetanically1648067____tetanically_
trophically2147557_tro__ph_ically_
tyrannically2054377tyr___annically_
untechnical1853217__untechnica_l__
volcanically2253347__vo_lcanically_

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 Filter178691950240.356501941.0
2DLD Change Limit950241019.48610017.3
3Display Results1011010.0761328.9
 (SQL Overall)1786911019.91818016.8
 
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.