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

36 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
commercially235414(None) 
commercial1855282commercia_l_
commerciality2463382commerciality
commercials1954312commercia_ls
chimerically2455013chimerically
comedically2156993co_medically
commensally2054793comme_nsally
commercialise21184163commercialise
commercialism20184183commercialism
commercialist21204683commercialist
commercialize30184033commercialize
cosmetically2147933cosmetically
cholerically2256154cholerically
clerically1748194c__lerically
coercibly1843654co__erci_bly
coercively2053484co__ercively
collegially1753414colle_gially
comically18310524co_m_ic_ally
commendably2353664comme_ndably
commercialised23193014commercialised
commercialises22173814commercialises
commercialisms21183664commercialisms
commercialists22183824commercialists
commercialized32203524commercialized
commercializes31193784commercializes
commercing1955974commerci__ng
communally1945004comm__unally
communicably2553764communicably
congenially1755904conge_nially
cordially1547484co___rdially
cosmically1948024cosm_ic_ally
imperially1746844_imper_ially
mesmerically2154824mesmerically
numerically1845904_numerically
symmetrically2554364symmetrically
uncommercial2062794uncommercia_l_

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 Filter1786911247900.406440125.6
2DLD Change Limit124790368.96613918.1
3Display Results36360.0162250.0
 (SQL Overall)178691369.38819034.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.