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

49 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
concentricity196372(None) 
centricity1746043___centricity
concentric1346133concentric___
concentrically2063773concentrically
concentricities1872913concentricities
eccentricity1862523_eccentricity
egocentricity2162523egocentricity
concentrate15118354concentr__ate
concentrating1856434concentrating
concentration1758014concentration
concentrative2056214concentrative
conceptuality2264474conceptuality
connectivity2254554connect_ivity
ethnocentricity2581714ethnocentricity
theocentricity2472014theocentricity
authenticity2063375authent_icity
bioelectricity2371805bioelectricity
canonicity1754415can_on__icity
centrality1547745___centrality
collectivity2254235collect_ivity
conceivability2663265conceivability
concentering1755445concent_ering
concentrated17116735concentr_ated
concentratedly2262175concentratedly
concentrates16118215concentr_ates
concentrations1877075concentrations
concentrator1655335concentr_ator
concentrators1754995concentrators
concertizing2655635concert_izing
concinnity1753425concin___nity
conductivity2353795conduct_ivity
congeneric1554675congeneric___
congeniality1854615congen_iality
conicity15411095co___n__icity
consanguinity1971265consanguinity
consentingly1854665consent_ingly
constrict13711625con__stric_t_
constricts1477735con__stric_ts
conventicle1854715convent_ic_le
conventicler1962815convent_icler
conventicles1954165convent_icles
convertibility2463275convertibility
domesticity1953685do_mest_icity
electricity1854955__electricity
noncontract1585585noncontrac_t_
noncreativity2162715noncreat_ivity
nonentity1246715non_ent___ity
oncogenicity2063285_oncogenicity
volcanicity2152615volcan__icity

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 Limit124790499.29613424.1
3Display Results49490.0301633.3
 (SQL Overall)178691499.71618391.4
 
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.