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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

119 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
restrictionisms196324(None) 
restrictionism1863781restrictionism_
restrictionists1764081restrictionists
restrictionist1665042restrictionis_t
abstractionisms21132663abstractionisms
destructionists1894223destructionists
obstructionisms2192803obstructionisms
restrictions1449283restriction___s
abstractionism20132954abstractionism_
abstractionists19143304abstractionists
destructionist17104964destructionis_t
obstructionism20103234obstructionism_
obstructionists19103384obstructionists
reductionisms1853794re__ductionisms
reservationists1873694reservationists
restriction1349364restriction____
restrictiveness2093414restrictivenes_s
abstractionist18133865abstractionis_t
associationisms19192345associationisms
destructions1547255destruction___s
deviationisms1953885de__viationisms
intuitionisms1563315_intui_tionisms
metafictionists2291815metafictionists
nutritionists1393705_nutri_tionists
obstructionist18113995obstructionis_t
perfectionisms2363295pe_rfectionisms
protectionisms2094025prot_ectionisms
recreationists1664375re_creationists
reductionism1754325re__ductionism_
reductionists1654655re__ductionists
repudiationists18212635repudiationists
reservationist17114335reservationis_t
restricting1449305restricti_n___g
restrictives1755085restrict___ives
resurrectionist1762835resurrectionis_t
retractions13910355re_traction___s
revisionisms17143865re__vi_sionisms
strictions1249145__striction___s
abolitionisms17153846_aboli_tionisms
abstractions1645786abstraction___s
aestheticisms2062666aest_heti_cisms
associationism18172606associationism_
associationists17183076associationists
constrictions1747786constriction___s
constructionist1984036constructionis_t
constructivisms24232816constructi_visms
creationisms1685526___creationisms
demolitionists1763476demoli_tionists
descriptions1755406description___s
destruction1446956destruction____
destructiveness2173806destructivenes_s
detractions14118276de_traction___s
detritions1148956de_tri_tion___s
deviationism1854026de__viationism_
deviationists17104746de__viationists
distractions1548756distraction___s
estheticisms1953206_est_heti_cisms
evolutionisms18124646_e_volutionisms
exhibitionisms2882056_exhibitionisms
expressionisms2562606_expressionisms
extortionists2074386_ext_ortionists
extractions2077746_extraction___s
extrications2149056_extrication___s
fictionists1655996____fictionists
instructions14137816instruction___s
intuitionism1453596_intui_tionism_
intuitionists1363896_intui_tionists
isolationisms1563746_is_olationisms
metafictionist2191866metafictionis_t
metrications1649836me_trication___s
metricisms1646526me_tric____isms
nutritionist12134516_nutri_tionis_t
obstructions16155526obstruction___s
operationisms1755096_oper_ationisms
partitionists1554766part_i_tionists
perfectionism2253986pe_rfectionism_
perfectionists2164016pe_rfectionists
prescriptions19135336prescription___s
preservationist2062806preservationis_t
protectionism1984946prot_ectionism_
protectionists18105146prot_ectionists
receptionists1754776re__ceptionists
recreationist1555746re_creationis_t
redirections1546176redirection___s
reductionist1555996re__ductionis_t
refractions16127726re_fraction___s
relictions12310026re__liction___s
religionists1354396re__li_gionists
repatriations15136516repatriation___s
repudiationist17183186repudiationis_t
resections121513036res__ection___s
reservations1588586reservation___s
resorptions1347236resor_ption___s
respirations14410306respiration___s
restationing1354266rest__ationi_ng
restations10315846rest__ation___s
restitutions1275706restitution___s
restorations12410956restoration___s
restrictive1646366restrict___i_ve
restrictively2153826restricti__vely
restricts1138826restrict______s
resurrections1553466resurrection___s
retraction121310536re_traction____
retributions14134946re_tribution___s
retroactions1447076re_troaction___s
retrodictions1655536re_trodiction___s
revisionism16144816re__vi_sionism_
revisionists15144806re__vi_sionists
revolutionises17154006re_volutionises
revolutionists17145126re_volutionists
rustications1448566rust_ication___s
salvationisms1873006__salvationisms
selectionists1556026__selectionists
separationists1664086separ_ationists
stictions1148356__st_iction___s
striations10312796__striation___s
striction1148986__striction____
strictness1245646__strict__nes_s
tectonisms1445576___t_ect_onisms

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 Limit950241198.11011716.9
3Display Results1191190.0931279.6
 (SQL Overall)1786911198.56320867.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.