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

77 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
restrictionism186378(None) 
restrictionisms1963241restrictionisms
restrictionist1665041restrictionist
restrictionists1764082restrictionists
restrictions1449282restriction_s_
abstractionism20132953abstractionism
destructionist17104963destructionist
obstructionism20103233obstructionism
restriction1349363restriction___
abstractionisms21132664abstractionisms
abstractionist18133864abstractionist
destructionists1894224destructionists
destructions1547254destruction_s_
obstructionisms2192804obstructionisms
obstructionist18113994obstructionist
reductionism1754324re__ductionism
reservationist17114334reservationist
restricting1449304restricti_n__g
restrictiveness2093414restrictiveness
restrictives1755084restricti_ves_
resurrectionist1762834resurrectionist
retractions13910354re_traction_s_
strictions1249144__striction_s_
abstractionists19143305abstractionists
abstractions1645785abstraction_s_
associationism18172605associationism
constrictions1747785constriction_s_
constructionist1984035constructionist
descriptions1755405description_s_
destruction1446955destruction___
detractions14118275de_traction_s_
detritions1148955de_tri_tion_s_
deviationism1854025de__viationism
distractions1548755distraction_s_
extractions2077745_extraction_s_
extrications2149055_extrication_s_
instructions14137815instruction_s_
intuitionism1453595_intui_tionism
metafictionist2191865metafictionist
metrications1649835me_trication_s_
nutritionist12134515_nutri_tionist
obstructionists19103385obstructionists
obstructions16155525obstruction_s_
perfectionism2253985pe_rfectionism
prescriptions19135335prescription_s_
preservationist2062805preservationist
protectionism1984945prot_ectionism
recreationist1555745re_creationist
redirections1546175redirection_s_
reductionisms1853795re__ductionisms
reductionist1555995re__ductionist
refractions16127725re_fraction_s_
relictions12310025re__liction_s_
repatriations15136515repatriation_s_
repudiationist17183185repudiationist
resections121513035res__ection_s_
reservationists1873695reservationists
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_
revisionism16144815re__vi_sionism
rustications1448565rust_ication_s_
stictions1148355__st_iction_s_
striations10312795__striation_s_
striction1148985__striction___

Search took 7 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 Limit95024776.09315595.6
3Display Results77770.0461673.9
 (SQL Overall)178691776.49927495.2
 
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.