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

99 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
abstractionisms2113266(None) 
abstractionism20132951abstractionism_
abstractionists19143301abstractionists
abstractionist18133862abstractionis_t
obstructionisms2192802obstructionisms
abstractions1645783abstraction___s
obstructionism20103233obstructionism_
obstructionists19103383obstructionists
restrictionisms1963243restrictionisms
abstractedness1962574abstractednes_s
abstraction1545884abstraction____
abstractional1753264abstraction__al
abstractness1683014abstract__nes_s
destructionists1894224destructionists
obstructionist18113994obstructionis_t
restrictionism1863784restrictionism_
restrictionists1764084restrictionists
abolitionisms17153845ab__olitionisms
abortionists1454975ab_or__tionists
abstracting1645185abstracti_n___g
abstractnesses1862295abstract_nesses
abstractors1554415abstract_o___rs
associationisms19192345associationisms
attractions1376405a_ttraction___s
destructionist17104965destructionis_t
distractions1548755distraction___s
isolationisms1563745_isola_tionisms
obstructions16155525obstruction___s
operationisms1755095_opera_tionisms
protectionisms2094025prot_ectionisms
restrictionist1665045restrictionis_t
aberrations1346696aberra_tion___s
abjurations2045146abjura_tion___s
abolitionism16134146ab__olitionism_
abolitionists15134226ab__olitionists
abortionist1356166ab_or__tionis_t
abreactions1544196ab_reaction___s
absorptions1544596absor_ption___s
abstentions1364366abst_ention___s
abstracters1544106abstract____ers
abstractest1553626abstract___es_t
abstractive1854896abstract___i_ve
abstractor1444386abstract_o____r
abstracts1346596abstract______s
abstricting1654506abstricti_n___g
actinisms1398886_____acti_nisms
adoptionisms1753356a___doptionisms
aestheticisms2062666aest_heti_cisms
agrarianisms1553026a__gra_rianisms
anachronisms1953076a___nachronisms
annexationists21192576annexa_tionists
antagonisms1494186a_nt_a__gonisms
arbitrations1445766arbitra_tion___s
associationism18172606associationism_
associationists17183076associationists
asynchronisms2362806a_s_ynchronisms
attraction1276956a_ttraction____
attractiveness1983556a_ttractivenes_s
biracialisms1853586_b_irac_ialisms
castrations13410056castra_tion___s
constructionist1984036constructionis_t
constructivisms24232816constructi_visms
contractions16410406contraction___s
creationisms1685526___creationisms
destructions1547256destruction___s
detractions14118276_detraction___s
deviationisms1953886_devia_tionisms
distraction1449116distraction____
extractions2077746_extraction___s
inflationisms1862956_infla_tionisms
instructions14137816instruction___s
intuitionisms1563316_int_uitionisms
isolationism1453946_isola_tionism_
isolationists1384656_isola_tionists
liberationists16143696libera_tionists
lustrations1147626lustra_tion___s
nutritionists1393706_nutr_itionists
obstruction15135546obstruction____
obstructiveness2273396obstructivenes_s
operationism1655866_opera_tionism_
operationists1556056_opera_tionists
ostracisms1444826_ostrac____isms
perfectionisms2363296_perfectionisms
protactiniums1961436prot_acti_niums
protectionism1984946prot_ectionism_
protectionists18105146prot_ectionists
protractions1646646protraction___s
reductionisms1853796__reductionisms
reservationists1873696reservationists
restrictions1449286restriction___s
retractions13910356_retraction___s
salvationisms1873006__salvationisms
selectionists1556026__selectionists
separationists1664086separa_tionists
stramoniums1552626__stra__moniums
strictions1249146__striction___s
subtractions1645376subtraction___s
tectonisms1445576___t_ect_onisms
tractions11511626___traction___s

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.373479064.3
2DLD Change Limit95024996.87613819.7
3Display Results99990.0761302.6
 (SQL Overall)178691997.32524394.7
 
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.