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

61 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
anticolonialist1710305(None) 
anticolonialism1982941anticolonialism
anticolonial1464073anticolonial___
neocolonialist1682043_neocolonialist
antisocialist15116334anti__socialist
colonialist1376724____colonialist
neocolonialism1882144_neocolonialism
neocolonialists1781704_neocolonialists
semicolonialism2181494semicolonialism
anticapitalist18314285antic_apitalist
anticlericalism2192375antic_lericalism
antiformalist18115025anti__formalist
antimaterialist17123855antimaterialist
antimonials1356905anti__monial_s_
antimonopolist1882615antimono_polist
antinationalist15163525antination_alist
antirationalist15214425antiration_alist
antiroyalist1556965anti__ro_yalist
antisocialists16114815anti__socialists
colonialism1565435____colonialism
colonialists1484995____colonialists
nationalist111412165nati___on_alist
neocolonialisms1991945_neocolonialisms
agriculturalist1872556agriculturalist
anecdotalist1562946an_ec_do_talist
anthologist15410466ant_holo___gist
anticapitalism20264296antic_apitalism
anticlericals1763166antic_lerical_s_
anticlinal1246386antic_lin_al___
anticlockwise2471126antic_lo_ckwise
anticodons13115516anticodon____s_
anticollision1562206anticol_li_sion
anticommunist19173816antic__ommunist
antielitist1158476anti_el__i_tist
antimalarials1563286antimalarial_s_
antimaterialism19123586antimaterialism
antimilitarist16163916antimil_itarist
antimonial1248396anti__monial___
antimonopolists19102076antimono_polists
antinomianism1764376anti__nomianism
antinovelist1564346anti__no_velist
antiozonant2093296anti_ozon_a__nt
antiozonants2182436anti_ozon_ants_
antiphonals1653696anti_phon_al_s_
antirationalism17214036antiration_alism
antirealist11910196anti____realist
antiroyalists1665096anti__ro_yalists
atonalist9411836a_t____on_alist
automobilist1692866aut__omobi_list
colonialisms1674756____colonialisms
colonialistic1773186____colonialistic
colonialize2254626____colonialize
colonials1147916____colonial_s_
intercolonial1563996intercolonial___
nationalise111910486nati___on_alise
nationalism131910376nati___on_alism
nationalists122010336nati___on_alists
neocolonial1352556_neocolonial___
pictorialist1675376__pic_torialist
rationalist111812126rati___on_alist
semicolonial1663056semicolonial___

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 Limit95024616.71614148.9
3Display Results61610.0461326.1
 (SQL Overall)178691617.12225090.0
 
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.