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

90 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
semiabstraction217671semiabstraction_
semiabstract1861234semiabstract____
abstraction1545885____abstraction_
abstractional1753265____abstractional
abstractions1645785____abstractions
abstracting1645186____abstracti_ng
administration17142556administra_tion_
administrations18162406administra_tions
demonstration16126286dem_onstra_tion_
demonstrational1862636dem_onstra_tional
demonstrations1795676dem_onstra_tions
distraction1449116__di__straction_
distractions1548756__di__stractions
ministration1465836__ministra_tion_
ministrations1555446__ministra_tions
registration1347536regi__stra_tion_
registrations1446896regi__stra_tions
remonstration15117126rem_onstra_tion_
remonstrations16116486rem_onstra_tions
sequestration22133136se_questra_tion_
sequestrations23182996se_questra_tions
subtraction1545626s___ub_traction_
subtractions1645376s___ub_tractions
abstractionism20132957____abstractionism
abstractionist18133867____abstractionist
abstractive1854897____abstracti_ve
abstractor1444387____abstract_o_r
abstractors1554417____abstract_ors
abstricting1654507____abstricti_ng
administrating1862137administra_ti_ng
attraction1276957____a_ttraction_
attractions1376407____a_ttractions
castration12410807___ca_stra_tion_
castrations13410057___ca_stra_tions
deconstruction19134437de_construction_
deconstructions20124367de_constructions
defenestration18173547defenestra_tion_
defenestrations1993307defenestra_tions
deliberation1546367deli_b_era_tion_
deliberations1645537deli_b_era_tions
demarcation1647027dem_a___rcation_
demarcations1746127dem_a___rcations
demonstrating17104767dem_onstra_ti_ng
destruction1446957de____struction_
destructions1547257de____structions
detraction13138587de_____traction_
detractions14118277de_____tractions
devastation1546737de_va_st_a_tion_
devastations1645827de_va_st_a_tions
distracting1569257__di__stracti_ng
elaboration1345747_e_lab_ora_tion_
elaborations1444927_e_lab_ora_tions
emigration13228217_emi___gra_tion_
emigrations14187157_emi___gra_tions
extraction1967987_e____xtraction_
extractions2077747_e____xtractions
fenestration1596077fe__nestra_tion_
fenestrations1695407fe__nestra_tions
instruction13137947___i_nstruction_
instructional1555097___i_nstructional
instructions14137817___i_nstructions
mastication15610297__m_a_stication_
mastications1649417__m_a_stications
mistracing1569607__mi__strac_i_ng
obstruction15135547____obstruction_
obstructions16155527____obstructions
reconstruction1894777re_construction_
reconstructions19124737re_constructions
redistricting1753787redi__stricti_ng
remigration14228917remi___gra_tion_
remigrations15227797remi___gra_tions
remonstrating1695557rem_onstra_ti_ng
reregistration1583137reregistra_tion_
reregistrations1672827reregistra_tions
restriction1349367re____striction_
restrictions1449287re____strictions
retraction121310537re_____traction_
retractions13910357re_____tractions
satisfaction17142117sati__s_faction_
satisfactions18141917sati__s_factions
sedimentation1654837sediment_a_tion_
sedimentations1754417sediment_a_tions
separation12510437se_pa___ra_tion_
separations1369277se_pa___ra_tions
sequestrating2352317se_questra_ti_ng
serialization22911727seria_liza_tion_
serializations23710937seria_liza_tions
substation1248997s___ubst_a_tion_
substations1348247s___ubst_a_tions
subtracting1645277s___ub_tracti_ng

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.360496363.9
2DLD Change Limit95024908.39011325.9
3Display Results90900.0761184.2
 (SQL Overall)178691908.82620246.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.