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

53 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
reorchestration2072831reorchestration_
reorchestrating2172272reorchestrati_ng
orchestration1883643__orchestration_
orchestrational2071873__orchestrational
orchestrations19113303__orchestrations
orchestrating1982844__orchestrati_ng
reorchestrate1872594reorchestrat___e
reorchestrated2072244reorchestrat__ed
reorchestrates1982414reorchestrat__es
orchestrator1782925__orchestrat_o_r
orchestrators1872655__orchestrat_ors
reconcentration1963995reconc_entration_
reforestation1654575refor__est_ation_
reforestations1754465refor__est_ations
reorientation1375595reor_ient_ation_
reorientations1465215reor_ient_ations
reregistration1583135re_registration_
reregistrations1672825re_registrations
concentration1758016_conc_entration_
concentrations1877076_conc_entrations
deconcentration20103626deconc_entration_
defenestration18173546de_fenestration_
defenestrations1993306de_fenestrations
deforestation1754306defor__est_ation_
deforestations1853966defor__est_ations
fenestration1596076fe___nestration_
fenestrations1695406fe___nestrations
forestation1447006_for__est_ation_
forestations1546326_for__est_ations
orchestrate1674126__orchestrat___e
orchestrated1873416__orchestrat__ed
orchestrater1773136__orchestrat__er
orchestraters1882456__orchestrat_ers
orchestrates1773796__orchestrat__es
perpetration1647136pe_r_pe_tration_
perpetrations1746376pe_r_pe_trations
preregistration1861756pre_registration_
reconcentrating2063346reconc_entrati_ng
refrigeration1764156refrige__ration_
refrigerations1863776refrige__rations
registration1347536re___gistration_
registrations1446896re___gistrations
reinfestation1664256re_infest_ation_
reinfestations1793886re_infest_ations
remonstration15117126re__monstration_
remonstrations16116486re__monstrations
reoperation13410906reo__pe__ration_
reoperations14410066reo__pe__rations
reorientating1473766reor_ient_ati_ng
representation16154126represent_ation_
representations17153896represent_ations
sequestration22133136se__questration_
sequestrations23182996se__questrations

Search took 5 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 Filter178691658740.330541487.9
2DLD Change Limit65874534.50014638.7
3Display Results53530.0461152.2
 (SQL Overall)178691534.87636647.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.