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

44 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
cherubically245260(None) 
acerbically2044673acer_bically
aerobically1848113_aerobically
chemically2248313che__mically
chronically2147803ch_ronically
clerically1748193cler__ically
cubically1846143c___ubically
heretically19410683_heretically
heroically18410623_her_oically
thermically2146683ther_mically
anaerobically2053374anaerobically
centrically1848234c_entrically
cerebrally1744004c_ereb_rally
chaotically2148454ch_aotically
cherubic1743304cherubic____
chimerically2455014chimerically
cholerically2256154cholerically
connubially1852484connubi_ally
cortically17411824c_or_tically
critically17411274c__ritically
crucially1645444c__ruci_ally
erotically15414314__erotically
hectically2049604_he_ctically
hedonically2046884_hedonically
helically1749434_he__lically
heraldically2154934_heraldically
herbicidally2351654_her_bicidally
hermetically2248384_hermetically
hieratically2048174hieratically
operatically1949324operatically
rhetorically2065864rhetorically
rubrically1774814___rubrically
schematically2555454schematically
spherically2146944spher__ically
sterically15410494ster__ically
theatrically2055694theatrically
theistically2067364theistically
thematically2257894thematically
theoretically2186254theoretically
thetically18410494the__tically
thoracically2285444thoracically
veridically2046084_veridically
vertically18410934_ver_tically
xerically2149534_xer__ically

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 Filter1786911247900.390458182.1
2DLD Change Limit124790446.36019621.1
3Display Results44440.0331333.3
 (SQL Overall)178691446.78326343.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.