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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

139 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
contaminators175488(None) 
contaminator1654991contaminator_
contaminates1656312contaminat_es
contaminations1886102contaminations
decontaminators2072092decontaminators
contaminants1693953contamina_nts
contaminate1556573contaminat__e
contaminated1755273contaminat_ed
contaminating1854913contaminating
contamination1766953contamination
contaminative2054373contaminative
contemplators1953573contemplators
continuators14105623cont__inuators
decontaminator1972323decontaminator_
comminatory2055244co__mminatory
conciliators1695394concili_ators
condemnatory2052864condem_natory
confabulators20142544confabulators
consolidators1653294consolidators
conspirators1655534con_spirators
consummators18134024consum_mators
contactors1448844conta___ctors
containers1249904conta_in__ers
contaminant1575844contamina__nt
contemnors1445244contem_n__ors
contemplator1853734contemplator_
continuator1386014cont__inuator_
contradictors1883634contradi_ctors
contributors16153914cont_ributors
coordinators1553804co_ordinators
decontaminates19112974decontaminat_es
denominators1574094den_ominators
dominators1397484do___minators
inseminators1453764_inseminators
intimidators1554164_intimidators
laminators1247054___laminators
nominators1277554__n_ominators
pontificators2053054pontificators
recontaminates18113034recontaminat_es
totalisators1251894to_talisators
totalizators2151794to_talizators
abominators1553915__abominators
anticipators1654675_anticipators
calumniators1652205c_alumniators
captivators1853625capt__ivators
castigators1445545cast__igators
chlorinators1753185c_hlorinators
cogitators1346005co___gitators
collaborators17142075collaborators
collimators1594785co__llimators
combinatory2054025co__mbinatory
commemorators1862455commemorators
commentators1854795co__mmentators
comminations18810485co__mminations
communicators2173985communicators
commutators1754435co__mmutators
comparators1785685compa__rators
concatenates1654535concatenat_es
concatenations1873725concatenations
concentrators1754995concentrators
conciliator1595595concili_ator_
conciliatory1994215concili_atory
condemnations1845405condem_nations
condemnors1543955condem_n__ors
confabulator19142715confabulator_
confabulatory23122275confabulatory
confiscators19113685con_fiscators
conglomerators1962215conglomerators
congratulators1762045congratulators
congregators1653835con_gregators
consecrators1656055con_secrators
conservators1755975con_servators
consolidator1553285consolidator_
conspirator1555655con_spirator_
constrictors1676015constri_ctors
consummator17134055consum_mator_
consummatory21133495consum_matory
contactor1348435conta___ctor_
contagions1346605contagi___ons
contagious1345355contagi___ous
containable1546205conta_ina_ble
container11311075conta_in__er_
containerport1771755conta_inerport
containerports1871165conta_inerports
containments1655785conta_inments
contains10316535conta_in____s
contemners1447075contem_n__ers
contemnor1344645contem_n__or_
contemplates1855285contemplat_es
contemplations2074735contemplations
conterminous1653285contermin__ous
continuations1547145cont__inuations
continuers1247945cont__in_uers
continuos1147005cont__in_uo_s
continuous1245725cont__in_uous
contractors1549165cont__ractors
contradictor1783825contradi_ctor_
contradictory2193175contradi_ctory
contributor15153965cont_ributor_
contributory19153215cont_ributory
coordinator1453525co_ordinator_
cultivators1653845cult__ivators
decontaminate18112915decontaminat__e
decontaminated20122715decontaminat_ed
decontaminating2162765decontaminating
decontamination2083255decontamination
denominator14104715den_ominator_
desalinators1353605_desalinators
determinators1653895determinators
disseminators1653085disseminators
dominator1258235do___minator_
eliminators1344815__eliminators
exterminators2252965exterminators
illuminators1453275_illuminators
inseminator1354245_inseminator_
intimidator1454535_intimidator_
intimidatory1853385_intimidatory
invalidators1652865_invalidators
laminator1147555___laminator_
motivators1545185mo_t__ivators
mountaintops1661185mounta_in_tops
navigators1464825__n_avigators
nominator1157825__n_ominator_
originators1253925_o_riginators
ostinatos946175_ost__inato_s
pollinators1354545po__llinators
pontificator1953465pontificator_
recontaminate17103195recontaminat__e
recontaminated19122925recontaminat_ed
recontaminating2062765recontaminating
recontamination1983545recontamination
ruminators1286065___ruminators
sonicators1277065son___icators
terminators1346035__terminators
totalisator1152105to_talisator_
totalizator2052395to_talizator_
uncontaminated1972835uncontaminat_ed
vaticinators1763385_vaticinators
ventilators14105065vent__ilators

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 Filter1786911247900.390458182.1
2DLD Change Limit1247901398.37614898.5
3Display Results1391390.0931494.6
 (SQL Overall)1786911398.85920170.6
 
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.