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

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

148 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
restrictionists1764081restrictionists_
restrictionisms1963242restrictionisms_
restrictionist1665042restrictionist__
destructionists1894223destructionists_
restrictionism1863783restrictioni__sm
abstractionists19143304abstractionists_
destructionist17104964destructionist__
obstructionists19103384obstructionists_
reservationists1873694reservationists_
restrictions1449284restriction___s_
abstractionisms21132665abstractionisms_
abstractionist18133865abstractionist__
metafictionists2291815metafictionists_
nutritionists1393705_nutri_tionists_
obstructionisms2192805obstructionisms_
obstructionist18113995obstructionist__
recreationists1664375re_creationists_
reductionists1654655re__ductionists_
repudiationists18212635repudiationists_
reservationist17114335reservationist__
restriction1349365restriction_____
restrictiveness2093415restrictivenes_s_
resurrectionist1762835resurrectionist__
abstractionism20132956abstractioni__sm
associationists17183076associationists_
constructionist1984036constructionist__
demolitionists1763476demoli_tionists_
destructions1547256destruction___s_
deviationists17104746de__viationists_
extortionists2074386_ext_ortionists_
fictionists1655996____fictionists_
intuitionists1363896_intui_tionists_
metafictionist2191866metafictionist__
nutritionist12134516_nutri_tionist__
obstructionism20103236obstructioni__sm
partitionists1554766part_i_tionists_
perfectionists2164016pe_rfectionists_
preservationist2062806preservationist__
protectionists18105146prot_ectionists_
receptionists1754776re__ceptionists_
recreationist1555746re_creationist__
reductionisms1853796re__ductionisms_
reductionist1555996re__ductionist__
reductionistic1962126re__ductionistic
religionists1354396re__li_gionists_
repudiationist17183186repudiationist__
restricting1449306restricti_n____g
restrictives1755086restrict___ives_
retractions13910356re_traction___s_
revisionists15144806re__vi_sionists_
revolutionists17145126re_volutionists_
selectionists1556026__selectionists_
separationists1664086separ_ationists_
strictions1249146__striction___s_
abolitionists15134227_aboli_tionists_
abortionists1454977_abor__tionists_
abstractions1645787abstraction___s_
associationisms19192347associationisms_
associationist16173357associationist__
coalitionists1583947_coali_tionists_
constrictions1747787constriction___s_
constructivists22223077constructi_vists_
contortionists16103367cont_ortionists_
corruptionists1862457_corruptionists_
creationists1476627___creationists_
demolitionist1654517demoli_tionist__
descriptions1755407description___s_
destruction1446957destruction_____
destructiveness2173807destructivenes_s_
destructivity2262707destructi_vi_t_y
detractions14118277de_traction___s_
detritions1148957de_tri_tion___s_
deviationisms1953887de__viationisms_
deviationist1656157de__viationist__
devolutionists18144417de_volutionists_
distractions1548757distraction___s_
educationists1654347_e_ducationists_
elocutionists1554317_e_locutionists_
evolutionists16145717_e_volutionists_
exhibitionists2662517_exhibitionists_
expressionists2363097_expressionists_
extortionist1975317_ext_ortionist__
extractions2077747_extraction___s_
extrications2149057_extrication___s_
fictionist1558027____fictionist__
instructions14137817instruction___s_
insurrectionist1772587insurrectionist__
intuitionisms1563317_intui_tionisms_
intuitionist1264997_intui_tionist__
isolationists1384657_is_olationists_
liberationists16143697liber_ationists_
metrications1649837me_trication___s_
obstructions16155527obstruction___s_
operationists1556057_oper_ationists_
oppositionists18132867opposi_tionists_
partitionist1456267part_i_tionist__
perfectionisms2363297pe_rfectionisms_
perfectionist2055337pe_rfectionist__
perfectionistic2471907pe_rfectionistic
perfusionists1863117pe__rfusionists_
precisionists1754637pre__ci_sionists_
preformationist2272227preformationist__
prescriptions19135337prescription___s_
prohibitionists2272077prohibi_tionists_
projectionists2594117_projectionists_
protectionisms2094027prot_ectionisms_
protectionist17116687prot_ectionist__
receptionist1656407re__ceptionist__
redirections1546177redirection___s_
reductionism1754327re__ductioni__sm
refractions16127727re_fraction___s_
relictions12310027re__liction___s_
religionist1255667re__li_gionist__
repatriations15136517repatriation___s_
repressionist1555327re_pressionist__
resections121513037res__ection___s_
reservations1588587reservation___s_
resorptions1347237resor_ption___s_
respirations14410307respiration___s_
restationing1354267rest__ationi__ng
restations10315847rest__ation___s_
restitutions1275707restitution___s_
restorations12410957restoration___s_
restraints1056607restr__ai_n__ts_
restrictive1646367restrict___i__ve
restrictively2153827restrict___ively
restricts1138827restric______ts_
resurrections1553467resurrection___s_
retractility1754007re_tracti_li_t_y
retraction121310537re_traction_____
retributions14134947re_tribution___s_
retroactions1447077re_troaction___s_
retrodictions1655537re_trodiction___s_
reunionists1154567re____unionists_
revisionisms17143867re__vi_sionisms_
revisionist14146527re__vi_sionist__
revolutionises17154007re_volutionises_
revolutionist16106187re_volutionist__
rustications1448567rust_ication___s_
salvationists1653567__salvationists_
segregationists17122297segregationists_
selectionist1458087__selectionist__
separationist1555277separ_ationist__
stictions1148357__st_iction___s_
striations10312797__striation___s_
striction1148987__striction_____
strictness1245647__strict__nes_s_
vivisectionists2371527vivisectionists_

Search took 10 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 Limit950241488.73310881.0
3Display Results1481480.1101345.5
 (SQL Overall)1786911489.20319416.6
 
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.