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

69 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
antiabortionist17101411antiabortionist_
antiabortion1462814antiabortion____
abortionist1356165____abortionist_
abortionists1454975____abortionists
contortionist15104426cont___ortionist_
contortionists16103366cont___ortionists
extortionist1975316ext___ortionist_
extortionists2074386ext___ortionists
abolitionist14145137____abolitionist_
abolitionists15134227____abolitionists
abortions1147787____abortion_s__
abstractionist18133867abstra__ctionist_
abstractionists19143307abstra__ctionists
accordionist1761877a___ccordionist_
accordionists1861497a___ccordionists
adoptionist1454967____adoptionist_
adoptionists1553927____adoptionists
annexationist20233037an__nexationist_
annexationists21192577an__nexationists
antagonist11106907ant_a____gonist_
antagonists1294807ant_a____gonists
antiaphrodisiac238967antiaphr__odisiac
antiarins9413897antia__r_i_n_s__
antiauthority1961417antia__uthori_ty
antibiosis1255947anti_b___iosis__
antibourgeois167987anti_bourgeo_is__
anticipations1757497anticipation_s__
anticommunist19173817anti_co_mmunist_
anticommunists20183097anti_co_mmunists
antifeminist1764687anti__femi_nist_
antifeminists1863487anti__femi_nists
antifertility1982907anti_ferti_li_ty
antiformalist18115017anti_for_malist_
antimaterialist17123837antimater_ialist_
antimodernist16164127anti_mo_dernist_
antimodernists17163147anti_mo_dernists
antimonopolist1882617anti_monopolist_
antimonopolists19102077anti_monopolists
antinationalist15163527anti__nationalist_
antinomianism1764377anti_no_mianis_m
antinomianisms1863697anti_no_mianisms
antiprotons1353847antipro_t_on_s__
antiquarianism25183397antiquar_ianis_m
antiquarianisms26182837antiquar_ianisms
antiquations2146247anti_quation_s__
antirationalist15214427anti__rationalist_
antisocialist15116337anti_so_cialist_
antisocialists16114817anti_so_cialists
antiterrorist1363377anti_ter_rorist_
antiterrorists1462567anti_ter_rorists
assimilationist1761797assimilationist_
contortionistic1971727cont___ortionistic
deviationist1656157devia___tionist_
deviationists17104747devia___tionists
exhibitionist2572917exhi_b_itionist_
exhibitionists2662517exhi_b_itionists
inflationist1555297infla___tionist_
inflationists1653847infla___tionists
integrationist1583687int_egrationist_
integrationists1682577int_egrationists
interventionist1862907interventionist_
intuitionist1264997int___uitionist_
intuitionists1363897int___uitionists
liberationist15124737__li_berationist_
liberationists16143697__li_berationists
metafictionist2191867met_afictionist_
metafictionists2291817met_afictionists
partitionist1456267parti____tionist_
partitionists1554767parti____tionists

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.360496363.9
2DLD Change Limit95024697.93611973.8
3Display Results69690.0501380.0
 (SQL Overall)178691698.34621410.4
 
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.