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

96 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
consecrators165605(None) 
consecrator1546381consecrator_
consecratory1954541consecratory
consecrates1548392consecrat_es
consecrations1749212consecrations
conservators1755972conservators
conspirators1655532conspirators
nonsecretors1452722nonsecretors
concentrators1754993concentrators
connectors1448183connec__tors
consecrate1448433consecrat__e
consecrated1646913consecrat_ed
consecrating1747943consecrating
consecration1649783consecration
consecrative1957313consecrative
conservator1656363conservator_
conservatory2054753conservatory
conspirator1555653conspirator_
consummators18134023consummators
convectors1768313convec__tors
convertors1549133conve_r_tors
cooperators1547003coope_rators
desecrators1445233_desecrators
nonsecretor1352903nonsecretor_
nonsecretory1762173nonsecretory
castrators1247444c_as_trators
celebrators1544404c_elebrators
coconspirators2061434coconspirators
cocreators1447134co___creators
cocurators1447304co__curators
coexecutors2261694coexec_utors
cogenerators1553984cogenerators
collectors1446594collec__tors
commemorators1862454commemorators
commentators1854794commentators
comparators1785684co_mparators
compensators1854374compensators
concentrator1655334concentrator_
concertos132711134conce_r_to_s
conciliators1695394conciliators
concoctors1346404con__coctors
condemnatory2052864condemnatory
conductors1546974conduc__tors
confiscators19113684confiscators
congregators1653834congregators
connecters1448014connec__ters
connector1347924connec__tor_
consecutions1647044consecutions
consenters12410844conse__nters
conservations1849094conservations
conservatoire1862764conservatoire
conservatoires1962184conservatoires
conservatories1962544conservatories
conservers1547684conse_r_vers
consociates1546544consociat_es
consociations1747514consociations
consolatory1684964cons_olatory
consolidators1653294consolidators
conspirations1747724conspirations
constellatory1862594constellatory
constrictors1676014constrictors
constructors1676474constructors
consultors1286404cons__ultors
consummator17134054consummator_
consummatory21133494consummatory
contactors1448844contac__tors
contemplators1953574contemplators
continuators14105624continuators
contractors1549164con__tractors
convector1648084convec__tor_
converters1539634conve_r_ters
convertor1448784conve_r_tor_
cooperator1446834coope_rator_
corporators1546654co_rporators
correctors1447494correc__tors
correlators1345594corre_lators
cunctators1443724cun__ctators
deconsecrates1894044deconsecrat_es
deconsecrations2064514deconsecrations
desecraters1444814_desecraters
desecrator1346004_desecrator_
execrators1946024__execrators
generators1147534gen_e_rators
inspirators1345554_inspirators
integrators1246524_integrators
moderators1386644mo_de_rators
nonsecrets1285294nonsecret__s
nonvectors1556284nonvec__tors
obsecrates1444584_obsecrat_es
operators11410754_o_pe_rators
reconsecrates1784424reconsecrat_es
reconsecrations1995104reconsecrations
secretors1145834___secretors
sonicators1277064son_ic_ators
tolerators1046734to_le_rators
venerators1347064ven_e_rators

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.1561145455.1
2DLD Change Limit124790969.03013819.5
3Display Results96960.0462087.0
 (SQL Overall)178691969.23219355.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.