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

59 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
antiseparatists1772491antiseparatists_
antiseparatist1673512antiseparatist__
pantisocratists1971855pantis_ocratists_
separatists1354505____separatists_
antimechanists2163256antime_chanists_
antimonarchists2272026antimonarchists_
antiparasitic1763236anti__parasi_tic
antiparties1347566anti__par_ti_es_
antiracists1357706anti____racists_
antirealists1297466antire___alists_
antiseptics1555406antisep___ti_cs_
antisexists1864016antise____xists_
antisocialists16114806antis_ocialists_
antiterrorists1462566antite_rrorists_
pantisocratist1872746pantis_ocratist__
separatisms1554656____separatisms_
separatist1247186____separatist__
separatistic1652986____separatistic
animatists1246887an_i____matists_
antepasts1145527ant__ep__a__sts_
anticapitalisms21273577anticapitalisms_
anticapitalist18314287anticapitalist__
anticipations1757497anticip__ations_
antidefamation2061497antidefamati__on
antiderivatives2281357antiderivatives_
antielitisms1454437anti_e__litisms_
antielitist1158457anti_e__litist__
antifascists1762977anti__fa_scists_
antifeminists1863487antife__minists_
antiliberalisms19173307antiliberalisms_
antimechanist2064377antime_chanist__
antimilitarists17153207antimilitarists_
antimodernists17163147antimoder_nists_
antimonarchist2172547antimonarchist__
antinarratives1792017anti_narratives_
antinepotism1663477antinep__oti__sm
antiparticle1663037anti__par_ti_cle
antiparticles1762377anti__par_ticles
antiphrases1654747anti__phra__ses_
antiphrasis1655387anti__phra__sis_
antipyretics19143967anti__pyreti_cs_
antiquarianisms26182837anti_quarianisms_
antiracisms1557507anti____racisms_
antiracist12410687anti____racist__
antirealisms1477137antire___alisms_
antirealist11910187antire___alist__
antiroyalists1665097anti__royalists_
antisepses1245077antisep_____ses_
antisepsis1255127antisep_____sis_
antiseptic1456607antisep___ti___c
antisexist1765897antise____xist__
antisexualities2263487antisexualiti_es_
antisexuality2364367antise_xuali_t_y
antisocialist15116327antis_ocialist__
antiterrorisms1672447antite_rrorisms_
antiterrorist1363377antite_rrorist__
comparatists1853737___comparatists_
separations1369277____separations_
separatism1455607____separati__sm

Search took 9 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.356501941.0
2DLD Change Limit95024598.36011366.5
3Display Results59590.0461282.6
 (SQL Overall)178691598.76220393.9
 
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.