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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

80 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
obstructionisms2192801obstructionisms_
obstructionism20103232obstructionism__
obstructionists19103382obstructionists_
abstractionisms21132663abstractionisms_
obstructionist18113993obstructioni__st
abstractionism20132954abstractionism__
abstractionists19143304abstractionists_
destructionists1894224destructionists_
obstructions16155524obstruction___s_
restrictionisms1963244restrictionisms_
abstractionist18133865abstractioni__st
constructionist1984035constructioni__st
constructivisms24232815constructi_visms_
destructionist17104965destructioni__st
obstruction15135545obstruction_____
obstructiveness2273395obstructivenes_s_
restrictionism1863785restrictionism__
restrictionists1764085restrictionists_
abstractions1645786abstraction___s_
constructions1747716construction___s_
constructivism23213686constructi_vism__
constructivists22223076constructi_vists_
destructions1547256destruction___s_
instructions14137816instruction___s_
intuitionisms1563316_int_uitionisms_
obstructing1644576obstructi_n____g
obstructives1953916obstruct___ives_
obstructors1564006obstruct_o___rs_
operationisms1755096o_per_ationisms_
protectionisms2094026prot_ectionisms_
reductionisms1853796__reductionisms_
restrictionist1665046restrictioni__st
abolitionisms17153847ab__olitionisms_
abortionists1454977ab_or__tionists_
abstractedness1962577abstractednes_s_
abstraction1545887abstraction_____
abstractional1753267abstraction___al
abstractness1683017abstract__nes_s_
associationisms19192347associationisms_
constrictions1747787constriction___s_
construction1648087construction_____
constructional1854767construction___al
constructivist21214197constructi_vi__st
corruptionists1862457_corruptionists_
creationisms1685527___creationisms_
destruction1446957destruction_____
destructiveness2173807destructivenes_s_
distractions1548757distraction___s_
evolutionisms18124647_evolu_tionisms_
instruction13137947instruction_____
instructional1555097instruction___al
instructiveness2064157instructivenes_s_
intuitionism1453597_int_uitionism__
intuitionists1363897_int_uitionists_
isolationisms1563747_is_olationisms_
nutritionists1393707_nutr_itionists_
objectivisms2863187ob__jecti_visms_
obscurations1644027obscuration___s_
observations1785017observation___s_
obstructive1854617obstruct___i__ve
obstructor1453757obstruct_o_____r
obstructs1344577obstruct______s_
obtrusions1263157ob_tru_sion___s_
obturations13116427ob_turation___s_
operationism1655867o_per_ationism__
operationists1556057o_per_ationists_
ostracisms1444827o_strac____isms_
perfectionisms2363297_perfectionisms_
protectionism1984947prot_ectionism__
protectionists18105147prot_ectionists_
reductionism1754327__reductionism__
reductionists1654657__reductionists_
reservationists1873697reservationists_
restrictions1449287restriction___s_
salvationisms1873007__salvationisms_
scrutinises1363307__scru_ti_nises_
selectionists1556027__selectionists_
strictions1249147__striction___s_
structuralisms1872227__structuralisms_
tectonisms1445577___t_ect_onisms_

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.376475242.0
2DLD Change Limit95024809.25010272.9
3Display Results80800.0461739.1
 (SQL Overall)178691809.67218475.1
 
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.