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

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

55 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
recontaminated1912292(None) 
decontaminated20122711decontaminated
recontaminate17103191recontaminate_
recontaminates18113031recontaminates
contaminated1755272__contaminated
decontaminate18112912decontaminate_
decontaminates19112972decontaminates
uncontaminated1972832uncontaminated
contaminate1556573__contaminate_
contaminates1656303__contaminates
decontaminator1972323decontaminator
recontaminating2062753recontaminating
recontamination1983543recontamination
contaminator1654994__contaminator
decontaminating2162754decontaminating
decontamination2083254decontamination
decontaminators2072094decontaminators
reconsolidated18132134reconsolidated
recontacted1654704reconta___cted
recriminated1754494rec__riminated
renominated14146974re__n_ominated
concatenated1753525__concatenated
contained12310895__conta_in__ed
contaminant1575845__contamina_nt
contaminants1693955__contaminants
contaminating1854905__contaminating
contamination1766955__contamination
contaminative2054375__contaminative
contaminators1754885__contaminators
contemplated1954445__contemplated
deaminated1448015de____aminated
decorticated18144165decort__icated
delaminated1545785de___laminated
denominated15166255de__n_ominated
predominated18124815predo___minated
prenominated17185205pre__n_ominated
recommitted1853875reco__mmi_tted
reconcentrated1983335reconcentrated
reconfined1645685recon__fin__ed
reconsecrated1884385recon_secrated
reconsolidate16122295reconsolidate_
reconsolidates17122225reconsolidates
reconstituted1653435recon_stituted
reconvicted1944275recon__vi_cted
reconvinced1953805recon__vin_ced
recriminate1555235rec__riminate_
recriminates1654885rec__riminates
recultivated1853115recult__ivated
reincarnated1552155re_inca_rnated
remotivated1744145remo_t__ivated
renominate12178425re__n_ominate_
renominates13137805re__n_ominates
reobtained1343395re_obta_in__ed
retaliated1148435re___tali_ated
uncontemplated2161715uncontemplated

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.1231452772.4
2DLD Change Limit95024557.69012356.8
3Display Results55550.0301833.3
 (SQL Overall)178691557.84322783.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.