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

92 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
orchestrational207187(None) 
orchestration1883642orchestration__
orchestrations19113302orchestration_s
orchestrating1982843orchestrati_n_g
orchestrator1782924orchestrat_o__r
orchestrators1872654orchestrat_o_rs
orientational1353804or_ient_ational
progestational1762754progest_ational
reorchestration2072834reorchestration__
arbitrational1553185ar__bitrational
demonstrational1862635demonstrational
gestational1245115___gest_ational
illustrational1461555_illustrational
operational1347525o__pe__rational
orchestral1573895orchestr_____al
orchestrate1674125orchestrat____e
orchestrated1873415orchestrat___ed
orchestrater1773135orchestrat___er
orchestraters1882455orchestrat__ers
orchestrates1773795orchestrat___es
presentational1673215present_ational
reorchestrating2172275reorchestrati_n_g
aberrational1453486__abe_rrational
abstractional1753266___abstractional
acculturational1971666acculturational
castration12410806__c_astration__
castrations13410056__c_astration_s
citational1266466__c__it_ational
coeducational1853296__coeducational
concentration1758016conc_entration__
concentrations1877076conc_entration_s
conservational1955346__conservational
conspirational1853966__conspirational
constructional1854766__constructional
contractional1756066__c_ontractional
correlational15113676cor_re__lational
dissertational1562576dissert_ational
documentational2061966document_ational
expectational2452496_expect_ational
fenestration1596076_fenestration__
fenestrations1695406_fenestration_s
forestation1447006for__est_ation__
forestations1546326for__est_ation_s
frustration1444816fr__ustration__
frustrations1544536fr__ustration_s
generational1354826___generational
gravitational1762556gr_avit_ational
hyperrational2153936_hype_rrational
incantational1553566inc_ant_ational
investigational1961936_investigational
irrational1047216ir_____rational
irrotational1254026ir__rot_ational
lactational1344656lac___t_ational
nonoperational1663776nonope__rational
observational1853186o_bse_rvational
occupational1883006o_c__cupational
ochlocratical1961436o_chlocrati_cal
orchestra1473936orchestr_____a_
orchestrally2062736orchestra___lly
orchestras1583526orchestr_____as
organizational2462096or_ganizational
orientation1147576or_ient_ation__
orientationally1872056or_ient_ationally
orientations1246916or_ient_ation_s
oscillational1552236osc__illational
perorational1446396___perorational
preoperational1853246pr_eoperational
prevocational2054016pr__evocational
prostration13410796pr__ostration__
prostrations1449766pr__ostration_s
protestation1456366protest_ation__
protestations1555816protest_ation_s
recreational1455176_r__ecreational
reformational18113426_r__eformational
registration1347536_registration__
registrations1446896_registration_s
relational1047716_r__e__lational
repetitional1453726_repe_t_itional
reputational1474586_r__eputational
restation9316916_r__est_ation__
restationed1244376_r__est_ationed
restations10315846_r__est_ation_s
restoration11412096_r__estoration__
restorations12410956_r__estoration_s
rotational1048096_r___ot_ational
sequestration22133136sequestration__
sequestrations23182996sequestration_s
stational948516_____st_ational
translational1354746tr_ans_lational
transnational1353916tr_ans_national
transpirational1773106transpirational
vegetational1653376_vege_t_ational

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.360496363.9
2DLD Change Limit95024927.53012619.4
3Display Results92920.0801150.0
 (SQL Overall)178691927.97022420.5
 
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.