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

73 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
prismatically229585(None) 
pragmatically2356262pragmatically
aromatically19410663ar_omatically
axiomatically2756083axiomatically
climatically2146533cli_matically
dramatically2047613dr_amatically
enigmatically2155023enigmatically
eristically16411343eris__tically
grammatically2364663grammatically
idiomatically2155553idiomatically
numismatically2362643numismatically
piratically18411213p_i_ratically
pneumatically2255463pneumatically
prosaically1847843pros_a_ically
puristically1948203puris__tically
schismatically2673323schismatically
stigmatically2154923stigmatically
traumatically2054753traumatically
adiabatically2153734adiabatically
aoristically1749364aoris__tically
aposematically2363804aposematically
arithmetically2453864arithmetically
artistically1748704artis__tically
asthmatically2355644asthmatically
automatically2077434automatically
chromatically2556944chromatically
cinematically2265744cinematically
climactically2153754cli_mactically
cosmetically2147924_cosmetically
critically17411274cri___tically
deistically1749044deis__tically
dogmatically2147064_dogmatically
drastically1748944dras__tically
ecstatically1956454_ecstatically
enzymatically3253584enzymatically
erratically16410124er__ratically
hieratically2048174_hieratically
isosmotically2053944isosmotically
isostatically1854994isostatically
judgmatically2952904judgmatically
juristically2446144juris__tically
kinematically2454724kinematically
meristically1949014meris__tically
mimetically2048304_mi_metically
osmotically1847774__osmotically
parasitically2056804paras_itically
pharisaically2354134pharis_a_ically
phatically20411314p___hatically
phlegmatically27103504phlegmatically
plastically1849404plas__tically
practically20410444pr__actically
pragmatical1854904pragmatica_l_
premaritally1963204pr_emaritally
presynaptically2771794presynaptically
primatial1348104pri_mati_a_l_
primatials1445034pri_mati_a_ls
prismatic1547164prismatic____
problematically2662044problematically
proleptically2256004proleptically
prophetically2577454prophetically
prosodically2056584pros_odically
prosthetically2454614prosthetically
puritanically2053754puri_tanically
rheumatically2354224rheumatically
romantically1948014_r_omantically
rustically1548974_rus__tically
schematically2555454schematically
seismically1846254seism__ically
somatically18411154__somatically
statically15411574___statically
talismanically2161794talismanically
thematically2257894_thematically
triadically1746064tri__adically

Search took 7 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 Limit95024735.76616480.1
3Display Results73730.0461587.0
 (SQL Overall)178691736.17228951.9
 
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.