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

99 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
pyrotechnically307216(None) 
pyrotechnical2562432pyrotechnica_l_
pyrometrically2654764pyrome_trically
pyrotechnic2352884pyrotechnic____
pyrotechnics2462504pyrotechnic___s
technically2146444____technically
biomechanically2971865_biomechanically
biotechnical2162865_biotechnica_l_
cryogenically2453395cryoge__nically
geotechnical2082385_geotechnica_l_
geotectonically23111605_geotectonically
gyroscopically2762235gyro_scopically
paratactically2353525paratac_tically
parochially2153185paro__ch_i_ally
photochemically3264095p_hotochemically
photogenically2564815p_hotogenically
proleptically2256005p_role_ptically
proteolytically2562455p_roteolytically
prototypically2662685p_rototypically
puritanically2053755purit__anically
pyrolytically2256095pyro__lytically
pyrotechnist2282975pyrotechni___st
pyrotechnists23102295pyrotechni__sts
zootechnical2861955_zootechnica_l_
abiogenically2163846abioge__nically
archaically2145826_ar___chaically
barometrically2353926barome_trically
botanically1847016__bot__anically
bronchially2152506_bro_nch_i_ally
chronically2147806chro____nically
cytogenetically2662856cytogenetically
epeirogenically23111866epeiroge__nically
erotically15414316_erot____ically
esoterically17126126_esote__rically
estrogenically2093246estroge__nically
ethnically1847836_____ethnically
exoterically24135776_exote__rically
gothically1946716__got__h_ically
hydromechanical3181616hydromechanica_l_
hydronically2455246hydro____nically
hydroponically2863206hydro__ponically
hygienically2483386hy_gie__nically
hypodermically3062176hypode_rmically
hypothetically3064396hypot_hetically
hysterically2354896hy_ste__rically
iatrogenically20103446iatroge__nically
irenically15710316_ir__e__nically
ironically151110546_iro____nically
isotonically1756056_isot__onically
mechanically2455596____mechanically
monogenically2154736monoge__nically
monotonically2055326monot__onically
moronically1849106moro____nically
mythically2345846my__t__h_ically
neurogenically2062966neuroge__nically
nontechnical1963526_nontechnica_l_
paragenetically2362726paragenetically
parametrically2354486parame_trically
participially2271946par_ticipi_ally
perennially1654606per__e_nni_ally
phonemically2456206p_hone__mically
phonetically2249096p_hone__tically
phonically2049026p_ho____nically
photically20411176p_hot____ically
photolytically2774286p_hotolytically
phototactically2762786phototac_tically
phytochemically3563796p_hytochemically
piratically18411226pirat____ically
platonically1945906p_lat__onically
poetically17412886p__o_e__tically
polemically2047646p__ole__mically
polyphonically2962166p__olyphonically
potentially1656806p__ote__ntially
practically20410446p_r__ac_tically
problematically2662046p_roblematically
prolifically2255486p_ro__lifically
prophetically2577456p_ro_phetically
prosaically1847846p_ro___saically
prosodically2056586p_ro__sodically
prosthetically2454616p_rosthetically
protectively2254726p_rotec_ti_vely
proverbially2252126p_rove_rbi_ally
provincially2253026p_ro__vincially
psychically2654996p___sych_ically
psychogenically3172376psychoge__nically
pyrogenicity2364056pyroge__nic_ity
strategically1954006strate__gically
syntactically2354416sy_ntac_tically
systematically2464106sy_stematically
systemically2254156sy_ste__mically
technical1646056____technica_l_
technicality2252726____technicality
technicals1753956____technica_ls
tectonically1946326____tectonically
tetanically1648066____tetanically
trophically2147556_tro__ph_ically
tyrannically2054376tyr___annically
untechnical1853216__untechnica_l_
volcanically2253346__vo_lcanically

Search took 9 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.360496363.9
2DLD Change Limit95024997.97011922.7
3Display Results99990.0761302.6
 (SQL Overall)178691998.40621257.6
 
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.