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

113 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
abstractionists1914330(None) 
abstractionisms21132661abstractionisms
abstractionist18133861abstractionist_
abstractionism20132952abstractionis_m
obstructionists19103382obstructionists
abstractions1645783abstraction___s
destructionists1894223destructionists
obstructionisms2192803obstructionisms
obstructionist18113993obstructionist_
restrictionists1764083restrictionists
abortionists1454974ab_or__tionists
abstractedness1962574abstractednes_s
abstraction1545884abstraction____
abstractional1753264abstraction__al
abstractness1683014abstract__nes_s
destructionist17104964destructionist_
obstructionism20103234obstructionis_m
restrictionisms1963244restrictionisms
restrictionist1665044restrictionist_
abolitionists15134225ab__olitionists
abortionist1356165ab_or__tionist_
abstractest1553625abstract___est_
abstracting1645185abstracti_n___g
abstractnesses1862295abstract_nesses
abstractors1554415abstract_o___rs
annexationists21192575annexa_tionists
associationists17183075associationists
attractions1376405a_ttraction___s
constructionist1984035constructionist_
distractions1548755distraction___s
isolationists1384655_isola_tionists
liberationists16143695libera_tionists
nutritionists1393705_nutr_itionists
obstructions16155525obstruction___s
operationists1556055_opera_tionists
protectionists18105145prot_ectionists
reservationists1873695reservationists
restrictionism1863785restrictionis_m
selectionists1556025__selectionists
separationists1664085separa_tionists
aberrations1346696aberra_tion___s
abjurations2045146abjura_tion___s
abolitionisms17153846ab__olitionisms
abolitionist14145136ab__olitionist_
abreactions1544196ab_reaction___s
absorptions1544596absor_ption___s
abstentions1364366abst_ention___s
abstracters1544106abstract____ers
abstractive1854896abstract___i_ve
abstractor1444386abstract_o____r
abstracts1346596abstrac______ts
abstricting1654506abstricti_n___g
accordionists1861496accor__dionists
adoptionists1553926a___doptionists
annexationist20233036annexa_tionist_
antagonists1294806a_nt_a__gonists
arbitrations1445766arbitra_tion___s
associationisms19192346associationisms
associationist16173356associationist_
attractants1352856a_ttract_an__ts
attraction1276956a_ttraction____
attractiveness1983556a_ttractivenes_s
castrations13410056castra_tion___s
constructivists22223076constructi_vists
contortionists16103366cont_ortionists
contractions16410406contraction___s
cooperationists1963196coopera_tionists
corruptionists1862456_corruptionists
creationists1476626___creationists
destructions1547256destruction___s
detractions14118276_detraction___s
deviationists17104746_devia_tionists
distraction1449116distraction____
educationists1654346_educa_tionists
extortionists2074386_ext_ortionists
extractions2077746_extraction___s
fictionists1655996____fictionists
inflationists1653846_infla_tionists
instructions14137816instruction___s
insurrectionist1772586insurrectionist_
integrationists1682576integra_tionists
intuitionists1363896_int_uitionists
isolationisms1563746_isola_tionisms
isolationist1255886_isola_tionist_
liberationist15124736libera_tionist_
lustrations1147626lustra_tion___s
metafictionists2291816metafictionists
nutritionist12134516_nutr_itionist_
obstruction15135546obstruction____
obstructiveness2273396obstructivenes_s
operationisms1755096_opera_tionisms
operationist1457946_opera_tionist_
partitionists1554766__partitionists
perfectionists2164016_perfectionists
projectionists2594116_projectionists
protectionisms2094026prot_ectionisms
protectionist17116686prot_ectionist_
protractions1646646protraction___s
recreationists1664376_recreationists
reductionists1654656__reductionists
reservationist17114336reservationist_
restrictions1449286restriction___s
resurrectionist1762836resurrectionist_
retractions13910356_retraction___s
salvationists1653566__salvationists
selectionist1458086__selectionist_
separationist1555276separa_tionist_
strategists1252886__stra_t_egists
strictions1249146__striction___s
subtractions1645376subtraction___s
tractions11511626___traction___s
vacationists1754586____vacationists
vivisectionists2371526vivisectionists

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.1431249587.4
2DLD Change Limit950241138.07611766.2
3Display Results1131130.0931215.1
 (SQL Overall)1786911138.31221498.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.