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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

48 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
circumcenters186265(None) 
circumcenter1763311circumcenter_
circumcisers1782753circumc_isers
circumvented2263213circumvente_d
circumvents2053693circumvent__s
chromocenters2261924chromocenters
circumciser1673224circumc_iser_
circumcises1683934circumc_ise_s
circumvent1954044circumvent___
circumventing2362864circumventing
circumvention2263254circumvention
circumventions2362944circumventions
documenters1652814_docum_enters
carburetters1651475carbu_retters
carpenters1445845car___penters
cementers1338315___cem_enters
chromocenter2172425chromocenter_
cinquecentos256985cinquecent_os
circularness1662125circularn_ess
circulates1489285circu__late_s
circulators1545735circu__lators
circumcircles1772125circumcircles
circumcise1583865circumc_ise__
circumcised1763235circumc_ise_d
circumcisions1883055circumcisions
circumferences2272095circumference_s
circumflexes2882105circumflexe_s
circumfuses20103375circum_fuse_s
circumjacent2462715circumjacent___
circumlunar1762395circumlun_ar_
circumscribes2062975circumscribe_s
circumstances1862295circumstance_s
commenters16139485___commenters
concenters14410585___concenters
cricketers1843895cric__ke_ters
cryometers1746005c_ryom_e_ters
documenter1553285_docum_enter_
drumbeaters1651845_dr_umbeaters
fermenters15116535fer__m_enters
incenters112510305_i___ncenters
incumbents1644285_incumbent__s
micrometers1749075microm_e_ters
orthocenters1752645_orthocenters
picometers1648285pi_com_e_ters
subcenters1446165___subcenters
tormenters1245825tor__m_enters
trumpeters1442635_tr_umpe_ters
viscometers1854945viscom_e_ters

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.390458182.1
2DLD Change Limit124790489.14313648.7
3Display Results48480.0301600.0
 (SQL Overall)178691489.56318685.7
 
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.