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 “restrictionist” with Change Limit: [1] [2] [3] [4] [5] [6]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

93 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
restrictionist166504(None) 
restrictionism1863781restrictionism
restrictionists1764081restrictionists
destructionist17104962destructionist
restrictionisms1963242restrictionisms
restrictions1449282restriction_s_
abstractionist18133863abstractionist
destructionists1894223destructionists
obstructionist18113993obstructionist
reservationist17114333reservationist
restriction1349363restriction___
resurrectionist1762833resurrectionist
abstractionism20132954abstractionism
abstractionists19143304abstractionists
constructionist1984034constructionist
destructions1547254destruction_s_
metafictionist2191864metafictionist
nutritionist12134514_nutri_tionist
obstructionism20103234obstructionism
obstructionists19103384obstructionists
preservationist2062804preservationist
recreationist1555744re_creationist
reductionist1555994re__ductionist
repudiationist17183184repudiationist
reservationists1873694reservationists
restricting1449304restricti_n__g
restrictiveness2093414restrictiveness
restrictives1755084restricti_ves_
retractions13910354re_traction_s_
strictions1249144__striction_s_
abstractionisms21132665abstractionisms
abstractions1645785abstraction_s_
associationist16173355associationist
constrictions1747785constriction_s_
demolitionist1654515demoli_tionist
descriptions1755405description_s_
destruction1446955destruction___
detractions14118275de_traction_s_
detritions1148955de_tri_tion_s_
deviationist1656155de__viationist
distractions1548755distraction_s_
extortionist1975315_ext_ortionist
extractions2077745_extraction_s_
extrications2149055_extrication_s_
fictionist1558025____fictionist
instructions14137815instruction_s_
insurrectionist1772585insurrectionist
intuitionist1264995_intui_tionist
metafictionists2291815metafictionists
metrications1649835me_trication_s_
nutritionists1393705_nutri_tionists
obstructionisms2192805obstructionisms
obstructions16155525obstruction_s_
partitionist1456265part_i_tionist
perfectionist2055335pe_rfectionist
preformationist2272225preformationist
prescriptions19135335prescription_s_
protectionist17116685prot_ectionist
receptionist1656405re__ceptionist
recreationists1664375re_creationists
redirections1546175redirection_s_
reductionism1754325re__ductionism
reductionists1654655re__ductionists
refractions16127725re_fraction_s_
relictions12310025re__liction_s_
religionist1255665re__li_gionist
repatriations15136515repatriation_s_
repressionist1555325re_pressionist
repudiationists18212635repudiationists
resections121513035res__ection_s_
reservations1588585reservation_s_
resorptions1347235resor_ption_s_
respirations14410305respiration_s_
restationing1354265rest__ationing
restations10315845rest__ation_s_
restitutions1275705restitution_s_
restorations12410955restoration_s_
restrictive1646365restrict___ive
restrictively2153825restricti_vely
restricts1138825restrict____s_
resurrections1553465resurrection_s_
retraction121310535re_traction___
retributions14134945re_tribution_s_
retroactions1447075re_troaction_s_
retrodictions1655535re_trodiction_s_
revisionist14146525re__vi_sionist
revolutionist16106185re_volutionist
rustications1448565rust_ication_s_
selectionist1458085__selectionist
separationist1555275separ_ationist
stictions1148355__st_iction_s_
striations10312795__striation_s_
striction1148985__striction___

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.343520965.0
2DLD Change Limit95024936.95313666.6
3Display Results93930.0631476.2
 (SQL Overall)178691937.35924282.0
 
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.