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

92 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
antimaterialist1712382(None) 
antimaterialism19123551antimaterialism
antibacterials1872374antibacterial_s_
antimalarials1563234antimalarial_s_
antinationalist15163524antinationalist
antirationalist15214414antirationalist
immaterialist1794124__immaterialist
materialist1349504____materialist
antibacterial1763115antibacterial___
anticapitalist18314265antica_pitalist
anticlericalism2192365anti_clericalism
anticolonialist17103055anticolonialist
antiformalist18115015anti__formalist
antiliberalism18173815antiliber_alism
antimalarial1464085antimalarial___
antimechanist2064375antim__echanist
antimodernist16164125antimoder__nist
antirationalism17214035antirationalism
antirealist11910175anti____realist
antisocialist15116315anti__socialist
antiterrorist1363375anti__terrorist
immaterialism16104075__immaterialism
immaterialists1883495__immaterialists
imperialist15107775___im_perialist
materialise1347825____materialise
materialism1548245____materialism
materialists1456965____materialists
multilateralist1772045multilater_alist
aerialist9914266_____a_erialist
animalist11511646an_im_____alist
animaters11129956an_imater____s_
animatist11410996an_imat_____ist
antiabortionist17101416anti_abortionist
antiarthritis1672706antiarthri_tis_
anticapitalism20264276antica_pitalism
anticlericals1763136anti_clerical_s_
anticolonialism1982946anticolonialism
antielitist1158436anti___eli_tist
antifeminist1764686anti__femi_nist
antiliberalisms19173296antiliber_alisms
antiliberals1493336antiliber_al_s_
antimalaria1354556antimalaria____
antimatters1354336antimatter____s_
antimechanists2163246antim__echanists
antimilitarist16163886antim_ilitarist
antimodernists17163136antimoder__nists
antimonarchist2172546antimonar_chist
antimonials1356896antim__onial_s_
antimonopolist1882616antim_onopolist
antinatural1153716antinatur_al___
antinovelist1564336antinove___list
antiquarianism25183386anti_quarianism
antiracist12410676anti____r_acist
antiradicalism1973126antira_dicalism
antirationality1872596antirationality
antirealism1388396anti____realism
antirealists1297446anti____realists
antiritualism1564796antirit__ualism
antiroyalist1556966anti___royalist
antisatellite13102186antisate__llite
antiseparatist1673516antisepar_atist
antisocialists16114796anti__socialists
antiterrorism1562906anti__terrorism
antiterrorists1462556anti__terrorists
aromatherapist2172166a_romather_apist
bilateralism1653696__bilater_alism
biomaterials1662136_biomaterial_s_
dematerialize25154906__dematerialize
editorialist1364646_edi__torialist
immaterialisms1793816__immaterialisms
immateriality2062626__immateriality
immaterialize2673536__immaterialize
imperialism17106916___im_perialism
imperialists16105386___im_perialists
industrialist1463666in_dust_rialist
intimaters1297856intimater____s_
literalist10411526__li__ter_alist
materialised1555456____materialised
materialises1447306____materialises
materialisms1657286____materialisms
materialistic1774006____materialistic
materiality1656066____materiality
materialize2247876____materialize
materials11510786____material_s_
multilateralism1972146multilater_alism
naturalist1048866_n___atur_alist
nonmaterial1356386_nonmaterial___
paternalist1358586____paternalist
pictorialist1675376__pi_ctorialist
rematerialize24144856__rematerialize
sentimentalist16155456sentim__entalist
universalist1563166un_i__versalist

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.1261418182.5
2DLD Change Limit95024929.14010396.5
3Display Results92920.123748.0
 (SQL Overall)178691929.38919032.0
 
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.