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

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

71 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
contaminations188610(None) 
contamination1766951contamination_
contaminating1854902contaminati_ng
contaminators1754882contaminat_ors
comminations18810463co__mminations
concatenations1873713concatenations
condemnations1845403condem_nations
contaminates1656303contaminat__es
contaminative2054373contaminati_ve
contaminator1654993contaminat_o_r
contemplations2074723contemplations
continuations1547143cont__inuations
decontamination2083253decontamination_
recontamination1983543recontamination_
canalizations24410434can_alizations
centralizations26157774centralizations
cohabitations2053454co_habitations
columniations1764784co_lumniations
combinations1897914co__mbinations
commination171111624co__mmination_
comminutions1894304co__mminutions
concatenation1764084concatenation_
conciliations1747194concili_ations
condemnation1746044condem_nation_
condonations1547994con__donations
confabulations2162804confabulations
conglutinations1862544conglutinations
connations12312934con____nations
consignations16105934con_signations
consociations1747504consoci_ations
consolidations1754734consolidations
conspirations1747714con_spirations
consternations16116034consternations
constipations1747674con_stipations
consummations1955154consum_mations
contaminant1575844contamina___nt
contaminants1693954contamina__nts
contaminate1556574contaminat___e
contaminated1755274contaminat__ed
contemplation1985264contemplation_
contentions13412084cont__en_tions
contestations1547734cont_estations
continuation1448194cont__inuation_
contradictions1954144contradi_ctions
contraventions19103564contraven_tions
contributions1754744cont_ributions
contritions13410894cont_ri__tions
coordinations1684984co_ordinations
covariations1745974co_vari_ations
criminations1648064c__riminations
culminations1646534c__ulminations
deaminations151010134__deaminations
decontaminating2162754decontaminati_ng
decontaminators2072094decontaminat_ors
delaminations1647944_delaminations
denominations16117854den_ominations
dominations14611044do___minations
examinations2167464__examinations
inseminations1546234_inseminations
intimidations1686664_intimidations
invaginations1755084_invaginations
laminations1339794___laminations
nominations13410534__n_ominations
notarizations2248784no_tarizations
optimisations17153444_optimisations
optimizations26155704_optimizations
pontifications2187904pontifications
recontaminating2062754recontaminati_ng
reexaminations23153414reexaminations
renominations15108304ren_ominations
transaminations17113424transaminations

Search took 4 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.0931921408.6
2DLD Change Limit65874713.17020780.4
3Display Results71710.0461543.5
 (SQL Overall)178691713.30954001.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.