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

100 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
insurrectionist177258(None) 
insurrections15104142insurrection_s_
resurrectionist1762832resurrectionist
insurrection14104383insurrection___
insurrectional1662603insurrection_al
insurrectionary2071343insurrectionary
interventionist1862904interventionist
resurrections1553464resurrection_s_
abstractionist18133865abs_tractionist
constructionist1984035cons_tructionist
destructionist17104965des_tructionist
indirections1556195in_direction_s_
inspections1546425ins__pection_s_
instructions14137815ins_truction_s_
integrationist1583685integr_ationist
interjections2277995interjection_s_
intersections1598965intersection_s_
interventionism2062375interventionism
intuitionist1264995intu___itionist
nutritionist12134515_n_utr_itionist
obstructionist18113995obs_tructionist
perfectionist2055335__perfectionist
restrictionist1665045res_trictionist
resurrection1453355resurrection___
resurrectional1661755resurrection_al
selectionist1458085__s_electionist
surjections2075285__surjection_s_
abstractionism20132956abs_tractionism
abstractionists19143306abs_tractionists
conservationist2084026cons_ervationist
corrections1548866__correction_s_
corruptionist1763036__corruptionist
creationist1379236____creationist
destructionists1894226des_tructionists
imperfections2254006imperfection_s_
impressionist1763986i__mpressionist
incorrectness1762056incorrect__ness
incorruptions1753266incorruption_s_
incretions1248656in__cre_tion_s_
incurvations1746386incu_rvation_s_
indirection1456386in_direction___
inductions1348806indu___ction_s_
indurations1249586indu_r_ation_s_
infarctions1645026in_far_ction_s_
infections15510236in___fection_s_
inflationist1555296in___flationist
inflections1646996in__flection_s_
infractions1646966in__fraction_s_
infuriations1547446infu_riation_s_
injections1948666in___jection_s_
injunctions2044886inju__nction_s_
inscriptions1654506ins_cription_s_
insertions10410346ins___ertion_s_
inspection1446666ins__pection___
inspirations1447306inspir_ation_s_
instruction13137946ins_truction___
instructional1555096ins_truction_al
insufflations19112626insufflation_s_
insulations11310236insu__lation_s_
integrationists1682576integr_ationists
intellections1565396intellection_s_
interactions14410466in_teraction_s_
interceptions1758186interception_s_
interdictions1667496interdiction_s_
interjection2198926interjection___
interjectional23195606interjection_al
interrelations1457616interrelation_s_
interruptions1565736interruption_s_
intersection14610186intersection___
intersectional16146256intersection_al
interventions1657516intervention_s_
introjections2255786introjection_s_
intuitionism1453596intu___itionism
intuitionists1363896intu___itionists
inunctions1246756in_u__nction_s_
irreligionist1461946i___rreligionist
isolationist1255886i_s__olationist
misdirections1854236misdirection_s_
nutritionists1393706_n_utr_itionists
obstructionism20103236obs_tructionism
obstructionists19103386obs_tructionists
perfectionism2253986__perfectionism
perfectionists2164016__perfectionists
projectionist2485256__projectionist
protectionist17116686__protectionist
recreationist1555746__recreationist
reductionist1555996redu___ctionist
reservationist17114336res_ervationist
restrictionism1863786res_trictionism
restrictionists1764086res_trictionists
resurrecting1553126resurrecti_n__g
segregationist1692916__segregationist
selectionists1556026__s_electionists
subjections2296356__subjection_s_
subjectivist26174156__subjecti_vist
subreptions1545886__subreption_s_
subsections1597106__subsection_s_
surjection1974906__surjection___
susurrations1244336susurr_ation_s_
vivisectionist2261736_vivisectionist

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.376475242.0
2DLD Change Limit950241006.68614212.4
3Display Results1001000.0761315.8
 (SQL Overall)1786911007.13825033.8
 
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.