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

117 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
contemplators195357(None) 
contemplator1853731contemplator_
contemplates1855282contemplat_es
contemplations2074732contemplations
contaminators1754883contaminators
contemplate1755203contemplat__e
contemplated1954443contemplat_ed
contemplating2054123contemplating
contemplation1985263contemplation
contemplative22123703contemplative
contemplatives23122773contemplatives
commemorators1862454commemorators
concentrators1754994concentrators
condemnatory2052864condem_natory
confabulators20142544confabulators
consecrators1656054conse_crators
conservators1755974conse_rvators
constellatory1862594conste_llatory
consummators18134024consum_mators
contaminator1654994contaminator_
contemnors1445244contem___nors
contempts1545064contemp__t__s
contemptuous1852054contemp_tuous
continuators14105624cont_inuators
correlators1345594corre__lators
counterplayers2153804counterplayers
interpolators1554854_interpolators
chelators1448165c__he__lators
cocreators1447135cocre___ators
coemploys1842765co__empl__oys
cogenerators1553985co_generators
collators11410345co____llators
collimators1594785collim__ators
commemorator1772615commemorator_
commentators1854795comme_ntators
commutators1754435co__mmutators
compactors18256255co___mpactors
comparators1785685co___mparators
compensators1854375compe_nsators
completers16298325co___mpleters
compradors1743785co___mpradors
concentrator1655335concentrator_
conciliators1695395con_ciliators
condemnations1845405condem_nations
condemnors1543955condem___nors
condolatory1754235con__dolatory
conepates13912285con_e_p_at_es
conepatls1385345con_e_p_at_ls
confabulator19142715confabulator_
confabulatory23122275confabulatory
confiscators19113685con_fiscators
congelations1549735conge__lations
conglomerators1962215conglomerators
congratulators1762045congratulators
congregators1653835con_gregators
connectors1448185conne___ctors
consecrator1546385conse_crator_
consecratory1954545conse_cratory
conservator1656365conse_rvator_
conservatory2054755conse_rvatory
consolatory1684965con__solatory
consolidators1653295consolidators
conspirators1655535con_spirators
constellates14174235conste_llat_es
constellations1654405conste_llations
consultors1286405con__sul_tors
consummator17134055consum_mator_
consummatory21133495consum_matory
contactors1448845cont___actors
contaminates1656315contaminat_es
contaminations1886105contaminations
contemners1447075contem___ners
contemnor1344645contem___nor_
contemplatively2771885contemplatively
contempo1444835contemp___o__
contemporaneous2171365contemporaneous
contemporaries2062525contemporaries
contemporary2162385contemp_orary
contemporizes2853205contemporizes
contempt1447475contemp__t___
contestations1547735conte_stations
contesters12410185conte___sters
continuator1386015cont_inuator_
contractors1549165cont__ractors
contradictors1883635contradictors
contraltos1246765cont_ral_to_s
contributors16153915cont_ributors
contumelious1661705contumel_ious
convectors1768315conve___ctors
convertors1549135conve___rtors
cooperators1547005coope__rators
copperplates1752225copperplat_es
correlator1245695corre__lator_
counterplans1687145counterpla__ns
counterplayer2055045counterplayer_
counterplays1995605counterpla__ys
counterplots16106235counterpl__ots
counterploys1995355counterpl__oys
cremators1369805c__rem__ators
decontaminators2072095decontaminators
emulators1148185____emulators
formulators1684235fo__rmulators
inseminators1453765_inseminators
integrators1246525_inte_grators
interpellators1662925_interpellators
interpolator1455765_interpolator_
intimidators1554165_intimidators
nomenclators1651915no_menclators
pontificators2053055pontificators
postulators1345255post__ulators
potentiators1453225po_tentiators
scintillators1562015scint_illators
stimulators1344665__stimulators
templars1255265___templa__rs
templates1348275___templat_es
uncontemplated2161715uncontemplat_ed
ventilators14105065vent__ilators

Search took 10 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.1531167915.0
2DLD Change Limit1247901178.97013911.9
3Display Results1171170.0761539.5
 (SQL Overall)1786911179.19919425.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.