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

78 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
constellatory186259(None) 
consecratory1954543cons_ecratory
conservatory2054753cons_ervatory
consolatory1684963cons__olatory
constellate13114563constellat__e
constellated15113573constellat_ed
constellates14174233constellat_es
constellating1653263constellating
constellation1554793constellation
constellations1654403constellations
conciliatory1994214con_ciliatory
condemnatory2052864con_demnatory
condolatory1754234con__dolatory
confabulatory23122274confabulatory
consecrator1546384cons_ecrator_
consecrators1656054cons_ecrators
conservator1656364cons_ervator_
conservators1755974cons_ervators
consummatory21133494cons_ummatory
contemplator1853734con_templator_
contemplators1953574con_templators
oscillatory16133104_o_scillatory
castellated1443275c_astellat_ed
castratory1545145c_ast__ratory
collator10310375co____llator_
collators11410345co____llators
commendatory2253235co_mmendatory
compensatory2163645co_mpensatory
conciliator1595595con_ciliator_
conciliators1695395con_ciliators
confabulator19142715confabulator_
confabulators20142545confabulators
confirmatory2253575con_firmatory
confiscatory22143025con_fiscatory
congratulatory2061735congratulatory
congregator1554115congre_gator_
congregators1653835congre_gators
conservatoire1862765cons_ervatoire
consistory1545575cons___istory
consolidator1553285consolidator_
consolidators1653295consolidators
conspirator1555655cons_pirator_
conspirators1655535cons_pirators
constabulary1961335constabula__ry
consternate1355125consternat__e
consternated1554115consternat_ed
consternates1455055consternat_es
consternating1654975consternating
consternation15106365consternation
consternations16116045consternations
constrictor1596125const_rictor_
constrictors1676015const_rictors
constructor1576525const_ructor_
constructors1676475const_ructors
consultor1176475cons__ul_tor_
consultors1286405cons__ul_tors
consummator17134055cons_ummator_
consummators18134025cons_ummators
continuator1386015con_tinuator_
continuators14105625con_tinuators
contributory19153215con_tributory
copulatory1745755co___pulatory
correlator1245695co_rre_lator_
correlators1345595co_rre_lators
cosignatory1752945co_s_ignatory
counsellor1253015couns_ell__or_
counsellors1352965couns_ell__ors
nonsecretory1762175nons_ecretory
observatory1952605_obs_ervatory
oscillator12133715_o_scillator_
oscillators13113645_o_scillators
osculatory1544945_o_s_culatory
postulator1246015po_st_ulator_
postulators1345255po_st_ulators
rostellar943965ro_stella__r_
scintillator1462105scin_tillator_
scintillators1562015scin_tillators
ventilatory17114125ven_t_ilatory

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.390458182.1
2DLD Change Limit124790789.09613719.2
3Display Results78780.0461695.7
 (SQL Overall)178691789.53218746.4
 
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.