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

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

57 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
concertmeisters2114119(None) 
concertmeister20121361concertmeister_
concertmasters2061542concertm_asters
concertmaster1962043concertm_aster_
concernments1865245concernme_nt__s
concertedness1855835concert_e_dness
concertgoers1752585concert___goers
concertizes24158585concert__i_ze_s
concretists1555465concret__ist__s
contesters12410195con___t_e_sters
counterfeiters19103745counter_fei_ters
colorimeters1653166co_lorime__ters
compromisers2051956co_mprom_is_ers
concatenates1654536conc_at_enate_s
concealments1854076concealme_nt__s
conceitedness1875166conceit_e_dness
conceivers1746316conc____ei_vers
concenters14410596conc____e_nters
concentrates16118216concent__rate_s
concentrators1754996concent__rators
conceptualises20144396conceptualis_e_s
conceptualists20104076conceptualist__s
conceptualizers3082756conceptualizers
conceptuses1774516concept__us_e_s
concernment1766216concernme_nt___
concertednesses2064216concertednesse_s
concertgoer1672666concert___goer_
concertgoings1961676concertgoi__ngs
concertinas15107566concert__i__nas
concertinos15158126concert__i__nos
concertize23169356concert__i_ze__
concertized25146366concert__i_ze_d
concessioners1753066conce__ssioners
concreteness1655056concret_e__ness
concretenesses1854166concretenesse_s
concretes13411476conc_r__e__te_s
concretisms1764436concret__is__ms
concretist1448196concret__ist___
concretizes24166006concret__i_ze_s
confectioners2073376confect__ioners
conferments1848326confer_me_nt__s
conformists1854186confor_m_ist__s
contentments1655486contentme_nt__s
contester11311196con___t_e_ster_
controverters1852476con_trove_rters
conventiclers2072096convent__iclers
conversers1547356conver____s_ers
converters1539636conver_____ters
convertibles1954626convert__ible_s
counterfeiter1874746counter_fei_ter_
countermeasures19122296counter_measures
covertnesses1746336co_vertne_sse_s
intermitters1454606_inter_m_itters
kapellmeisters227376_kapellmeisters
northeasters1553406__n_ortheasters
overmasters1644826_o_ver_m_asters
tenderometers1652716tenderome__ters

Search took 8 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 Limit95024577.17313247.5
3Display Results57570.0461239.1
 (SQL Overall)178691577.57923577.1
 
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.