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

86 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
congregating175428(None) 
congregation16226762congregation
congregations17186412congregations
aggregating1343593_aggregating
cocreating15310293co_cre_ating
concreting1539873concre__ting
congealing1447633cong_e_aling
congesting14410113cong_e_sting
conglobating1853163conglobating
congregant1454573congrega__nt
congregate1445243congregat__e
congregated1644733congregat_ed
congregates1545503congregat_es
congregational1863433congregational
congregator1554113congregat_or
congregators1653833congregators
congressing1545603congre_ssing
conjugating2244503con_jugating
corelating13511583co__relating
correlating1487083co_rrelating
corrugating1544263co_rrugating
segregating1445453_segregating
abnegating1444474abn__egating
coagulating1545074coag_ulating
codirecting1743644codire_cting
coerecting15218784co_ere_cting
cogitating1447214co_g_itating
colligating1545714co_lligating
concatenating1853264concatenating
concealing1549304con_ce_aling
conceiting15311774con_ce_iting
concerting15313894con_ce_rting
conciliating1775624conciliating
concretizing2654304concretizing
confecting18310554con_fe_cting
confederating2054014confederating
confiscating2053614confiscating
conflating16410004con__flating
confronting1744864confr_onting
congaing1239824con___ga_ing
congeeing1337904cong_e__eing
congelation14410344cong_elation
congelations1549734cong_elations
conglomerating2062424conglomerating
congratulating1862144congratulating
congregants1553154congrega_nts
connecting15310384con_ne_cting
consecrating1747944consecrating
consenting13313224con_se_nting
consociating1755574consociating
constellating1653264constellating
consternating1654974consternating
constipating1775394constipating
consummating1953664consummating
contenting13313324con_te_nting
contesting13312214con_te_sting
contracting16610474contr_acting
contrasting1459354contr_asting
contributing1754304contributing
convecting18310434con_ve_cting
conventing16311544con_ve_nting
converging1758094converg__ing
converting16313134con_ve_rting
cooperating1648424co_operating
coparenting1644614copare_nting
copyreading2052754copyre_ading
copyrighting2451634copyrighting
coronating13410174co__ronating
corotating1349324co__rotating
correcting15199304co_rre_cting
creating113921954c___re_ating
cremating14312204c___remating
desegregating1752734desegregating
entreating11811554_entre_ating
foredating1577124fo__redating
intreating11614014_intre_ating
mongrelizing2552384mongrelizing
negating102012834__n__egating
nonbreathing1852104nonbre_athing
nonoperating1555414nonoperating
nonreading1246884non_re_ading
nonrotating1246304non_rotating
overeating141016534_overe_ating
reaggregating1552564reaggregating
resegregating1652844resegregating
uncreating13310474_uncre_ating

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 Filter1786911247900.406440125.6
2DLD Change Limit124790867.39016886.3
3Display Results86860.0461869.6
 (SQL Overall)178691867.84222786.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.