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
abstractions1645773abstraction___s
destructionists1894213destructionists
obstructionisms2192803obstructionisms
obstructionist18113993obstructionist_
restrictionists1764083restrictionists
abortionists1454964ab_or__tionists
abstractedness1962564abstractednes_s
abstraction1545884abstraction____
abstractional1753254abstraction__al
abstractness1683004abstract__nes_s
destructionist17104954destructionist_
obstructionism20103234obstructionis_m
restrictionisms1963244restrictionisms
restrictionist1665044restrictionist_
abolitionists15134205ab__olitionists
abortionist1356165ab_or__tionist_
abstractest1553625abstract___est_
abstracting1645185abstracti_n___g
abstractnesses1862295abstract_nesses
abstractors1554405abstract_o___rs
annexationists21192575annexa_tionists
associationists17183075associationists
attractions1376395a_ttraction___s
constructionist1984035constructionist_
distractions1548725distraction___s
isolationists1384645_isola_tionists
liberationists16143695libera_tionists
nutritionists1393695_nutr_itionists
obstructions16155515obstruction___s
operationists1556055_opera_tionists
protectionists18105135prot_ectionists
reservationists1873695reservationists
restrictionism1863785restrictionis_m
selectionists1556015__selectionists
separationists1664085separa_tionists
aberrations1346686aberra_tion___s
abjurations2045146abjura_tion___s
abolitionisms17153846ab__olitionisms
abolitionist14145136ab__olitionist_
abreactions1544196ab_reaction___s
absorptions1544586absor_ption___s
abstentions1364366abst_ention___s
abstracters1544096abstract____ers
abstractive1854896abstract___i_ve
abstractor1444376abstract_o____r
abstracts1346596abstrac______ts
abstricting1654496abstricti_n___g
accordionists1861496accor__dionists
adoptionists1553906a___doptionists
annexationist20233036annexa_tionist_
antagonists1294806a_nt_a__gonists
arbitrations1445756arbitra_tion___s
associationisms19192346associationisms
associationist16173356associationist_
attractants1352856a_ttract_an__ts
attraction1276956a_ttraction____
attractiveness1983546a_ttractivenes_s
castrations13410056castra_tion___s
constructivists22223076constructi_vists
contortionists16103356cont_ortionists
contractions16410386contraction___s
cooperationists1963186coopera_tionists
corruptionists1862456_corruptionists
creationists1476606___creationists
destructions1547236destruction___s
detractions14118266_detraction___s
deviationists17104746_devia_tionists
distraction1449106distraction____
educationists1654346_educa_tionists
extortionists2074376_ext_ortionists
extractions2077736_extraction___s
fictionists1655996____fictionists
inflationists1653846_infla_tionists
instructions14137806instruction___s
insurrectionist1772576insurrectionist_
integrationists1682576integra_tionists
intuitionists1363886_int_uitionists
isolationisms1563736_isola_tionisms
isolationist1255886_isola_tionist_
liberationist15124726libera_tionist_
lustrations1147626lustra_tion___s
metafictionists2291816metafictionists
nutritionist12134516_nutr_itionist_
obstruction15135546obstruction____
obstructiveness2273356obstructivenes_s
operationisms1755086_opera_tionisms
operationist1457936_opera_tionist_
partitionists1554746__partitionists
perfectionists2164016_perfectionists
projectionists2594116_projectionists
protectionisms2094006prot_ectionisms
protectionist17116666prot_ectionist_
protractions1646616protraction___s
recreationists1664376_recreationists
reductionists1654646__reductionists
reservationist17114336reservationist_
restrictions1449276restriction___s
resurrectionist1762836resurrectionist_
retractions13910346_retraction___s
salvationists1653566__salvationists
selectionist1458076__selectionist_
separationist1555276separa_tionist_
strategists1252876__stra_t_egists
strictions1249126__striction___s
subtractions1645366subtraction___s
tractions11511616___traction___s
vacationists1754576____vacationists
vivisectionists2371526vivisectionists

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.1261418182.5
2DLD Change Limit950241136.98313607.9
3Display Results1131130.0931215.1
 (SQL Overall)1786911137.20224811.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.