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

65 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
collegialities176304(None) 
collegiality1863223collegialit__y
colloquialities2671883colloquialities
congenialities1774193congenialities
illegalities1353883_illeg_alities
coequalities2355544co__equalities
coevalities1646784co__e_valities
coilabilities1748074coilabi_lities
collateralities17152334collateralities
collectivities2174164collectivities
collegiate1345074collegia__t_e_
collinearities1662174collinearities
commercialities2363304commercialities
conjugalities2353004conjug_alities
connubialities1862594connubialities
convivialities2262774convivialities
cordialities1546124co__rdialities
illegibilities1754404_illegibilities
illogicalities17132524_illogicalities
legalities1148914___leg_alities
cellularities1562405cell_ularities
classicalities1862535c_lassicalities
colemanites1544695co_le_manit_es
colinearities1553715co_linearities
collegial1245735collegial_____
collegially1753405collegial___ly
collegians1344425collegia____ns
collegiately18101715collegia__tely
colligates1347715collig_a__t_es
colonializes2354395co_loniali_zes
comicalities1846955co__micalities
commonalities1965135co_mmonalities
communalities1954825co_mmunalities
conceptualities2174285conceptualities
coplanarities1752665copl_anarities
corporalities1755285co_rporalities
corporealities1863205corporealities
corrigibilities2092765corrigibilities
culpabilities1946005culpabi_lities
cyclicalities1953035cycl_icalities
fallibilities1854545fallibi_lities
genialities12148645___genialities
gullibilities1653765gullibi_lities
illegalizes21133245_illeg_ali_zes
integralities1495505_integralities
jovialities2145165jo___vialities
labialities1347035___labialities
legibilities1547475___legibilities
lethalities1446395___lethalities
lexicalities2154725___lexicalities
logicalities1555055___logicalities
malleabilities1874975malleabilities
materialities1566395_materialities
molalities121110285mo_l___alities
originalities1464885_o_riginalities
polytonalities1982745polytonalities
potentialities1674195potentialities
regalities11410585___reg_alities
socialities1349285so___cialities
solubilities1446005so_lubi_lities
solvabilities1846895solvabi_lities
specialities1656775__specialities
venialities14168935___venialities
volatilities1546515vo_lati_lities
volubilities1745125vo_lubi_lities

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.1261418182.5
2DLD Change Limit95024657.32612970.8
3Display Results65650.0461413.0
 (SQL Overall)178691657.49823831.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.