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

51 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
overorchestrate2381421overorchestrate_
reorchestrate1872594_re_orchestrate_
reorchestrated2072244_re_orchestrated
reorchestrates1982414_re_orchestrates
orchestrate1674125____orchestrate_
orchestrated1873415____orchestrated
orchestrater1773135____orchestrater
orchestrates1773795____orchestrates
orchestraters1882456____orchestraters
orchestrator1782926____orchestrator
overaccentuate2171546over_accentuate_
overaccentuated2371476over_accentuated
overaccentuates2271516over_accentuates
overoperate1676696overo__pe__rate_
overoperated1876046overo__pe__rated
overoperates17116616overo__pe__rates
reorchestrating2172276_re_orchestrating
reorchestration2072836_re_orchestration
deconcentrate1873477_deconc_entrate_
deconcentrated2093007_deconc_entrated
deconcentrates1993147_deconc_entrates
orchestra1473937____orchestr___a
orchestral1573897____orchestra__l
orchestrally2062737____orchestrally
orchestras1583527____orchestra__s
orchestrating1982847____orchestrating
orchestration1883647____orchestration
orchestrators1872657____orchestrators
overarches1846837overarches______
overconstructed23112397ove__rconstructed
overdecorate1853747ove__r_decorate_
overdecorated2053447ove__r_decorated
overdecorates1953437ove__r_decorates
overestimate1775197ove__r__estimate_
overestimated19144857ove__r__estimated
overestimates1854867ove__r__estimates
overheated1739487ove__r_he___ated
overprescribe2282267overpr__escribe_
overprescribed2481947overpr__escribed
overprescribes2382037overpr__escribes
overregulate1684497over_r__egulate_
overregulated1894427over_r__egulated
overregulates1794547over_r__egulates
overreported1863447over_r__epor_ted
overstate121010867ove__r___st_ate_
overstated14119447ove__r___st_ated
overstates131110117ove__r___st_ates
overtreated1547417overtr__e___ated
reconcentrate1793897_reconc_entrate_
reconcentrated1983347_reconc_entrated
reconcentrates1893487_reconc_entrates

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.376475242.0
2DLD Change Limit95024518.40611304.3
3Display Results51510.0301700.0
 (SQL Overall)178691518.81220278.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.