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

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

47 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
multiracialisms2172031multiracialisms_
multiracialism2072322multiracialism__
biracialisms1853585___biracialisms_
multiracial1554505multiracial_____
ultrarealisms15123885_ult_rarealisms_
antiradicalisms2072676_antiradicalisms_
biracialism1753966___biracialism__
materialisms1657306m_ater__ialisms_
multilateralism1972146multilateralism__
racialisms1447226_____racialisms_
ultrarealism14114266_ult_rarealism__
ultrarealists13133656_ult_rarealists_
anticapitalisms21273577_anticapitalisms_
antiracisms1557507_antirac___isms_
antiradicalism1973137_antiradicalism__
antirealisms1477137_antir__ealisms_
antiritualisms1664227_antiritualisms_
antisocialists16114807_antisocialists_
clericalisms1893977_cl_eric_alisms_
commercialisms21183667commer_cialisms_
gutturalisms1552267guttur___alisms_
immaterialisms1793837immater__ialisms_
manorialisms1664487m_anor__ialisms_
materialises1447327m_ater__ialises_
materialism1548267m_ater__ialism__
materialists1456987m_ater__ialists_
millenarianisms19162287millenarianisms_
millennialisms1871967mil_lennialisms_
multiaxial1954227multi_axial_____
multilateralist1772047multilaterali__st
multilingualism2081377multilingualism__
multinomials1662227multinomial___s_
multiplications2163187multiplications_
multireligious1771237multireli_gious_
musicalises1554017mu_si__c_alises_
mutualisms1444507mu_t____ualisms_
officialisms2262317_offi__cialisms_
pictorialisms1984587pictor__ialisms_
provincialisms23102227provi_ncialisms_
racialism1348337_____racialism__
racialists1247707_____racialists_
ultraisms1146637_ult_r___a_isms_
ultraleftisms1882067_ult_raleftisms_
ultrarealist12114557_ult_rareali__st
ultrarealistic16142307_ult_rarealistic
ultraroyalists1782147_ult_raroyalists_
unitarianisms1563917_u_nitarianisms_

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 Filter178691950240.360496363.9
2DLD Change Limit95024478.78310819.1
3Display Results47470.0461021.7
 (SQL Overall)178691479.18919446.2
 
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.